MongoDB - Revision history

Donsez: /* Manipulation de données géographiques GeoJSON */

2014-11-13T04:41:48Z

Manipulation de données géographiques GeoJSON

← Older revision		Revision as of 04:41, 13 November 2014
Line 255:		Line 255:

	===Manipulation de données géographiques [[GeoJSON]]===		===Manipulation de données géographiques [[GeoJSON]]===

			Commandes [http://docs.mongodb.org/manual/reference/command/geoNear/ geoNear], [http://docs.mongodb.org/manual/reference/command/geoSearch/ geoSearch]
	====Avec 2dsphere====		====Avec 2dsphere====
	<pre>		<pre>

2014-11-13T04:40:35Z

Avec Haystack Index

← Older revision		Revision as of 04:40, 13 November 2014
Line 322:		Line 322:

	<pre>		<pre>
	{ ~~_id~~ : 100, pos: { lng : 126.9, lat : 35.2 } , type : "restaurant"}		db.places.insert({ poi : 100, pos: { lng : 126.9, lat : 35.2 } , type : "restaurant"})
	{ ~~_id~~ : 200, pos: { lng : 127.5, lat : 36.1 } , type : "restaurant"}		db.places.insert({ poi : 200, pos: { lng : 127.5, lat : 36.1 } , type : "restaurant"})
	{ ~~_id~~ : 300, pos: { lng : 128.0, lat : 36.7 } , type : "national park"}		db.places.insert({ poi : 300, pos: { lng : 128.0, lat : 36.7 } , type : "national park"})

	db.places.ensureIndex( { pos : "geoHaystack", type : 1 } ,		db.places.ensureIndex( { pos : "geoHaystack", type : 1 } ,
	{ bucketSize : 1 } )		{ bucketSize : 1 } )


	db.runCommand( { geoSearch : "places" ,		db.runCommand( { geoSearch : "places" ,

2014-11-13T04:37:40Z

Avec 2d

@@ Line 302: / Line 302: @@
 <pre>
 db.places.find( { loc :
@@ Line 313: / Line 315: @@
                 } } } )
 </pre>

2014-11-13T04:29:18Z

Agrégation par Map-Reduce

← Older revision		Revision as of 04:29, 13 November 2014
Line 251:		Line 251:

	db.map_reduce_example2.find()		db.map_reduce_example2.find()

			</pre>

			===Manipulation de données géographiques [[GeoJSON]]===
			====Avec 2dsphere====
			<pre>

			db.places.insert(
			{
			loc : { type: "Point", coordinates: [ -73.97, 40.77 ] },
			name: "Central Park",
			category : "Parks"
			}
			)

			db.places.insert(
			{
			loc : { type: "Point", coordinates: [ -73.88, 40.78 ] },
			name: "La Guardia Airport",
			category : "Airport"
			}
			)

			db.places.ensureIndex( { loc : "2dsphere" , category : -1, name: 1 } )


			db.places.find( { loc :
			{ $geoWithin :
			{ $geometry :
			{ type : "Polygon" ,
			coordinates : [ [
			[ 0 , 0 ] ,
			[ 3 , 6 ] ,
			[ 6 , 1 ] ,
			[ 0 , 0 ]
			] ]
			} } } } )

			db.places.find( { loc :
			{ $geoWithin :
			{ $centerSphere :
			[ [ -88 , 30 ] , 10 / 3959 ]
			} } } )


			</pre>

			====Avec 2d====

			<pre>


			db.places.find( { loc :
			{ $geoWithin :
			{ $box : [ [ 0 , 0 ] ,
			[ 100 , 100 ] ]
			} } } )

			db.places.find( { loc: { $geoWithin :
			{ $center : [ [-74, 40.74 ] , 10 ]
			} } } )

	</pre>		</pre>

2014-10-28T21:56:18Z

Modification et Suppression

← Older revision		Revision as of 21:56, 28 October 2014
Line 257:		Line 257:

	<pre>		<pre>

			db.persons.update(
			{ job: "Professor" } ,
			{ $inc: { likes: 1 } },
			{ multi: true }
			)

	// script de modification des champs "address"		// script de modification des champs "address"
	db.persons.find( { address: {$ne : null}}).forEach(		db.persons.find( { address: {$ne : null}}).forEach(
Line 270:		Line 277:
	// suppression de persons de la collection		// suppression de persons de la collection

	db.persons.remove( { ~~likes~~: { $exists: false } } )		db.persons.remove( { job: { $exists: false } } )

	exit		exit

2014-10-28T08:31:55Z

Agrégation par Map-Reduce

← Older revision		Revision as of 08:31, 28 October 2014
Line 252:		Line 252:
	db.map_reduce_example2.find()		db.map_reduce_example2.find()

			</pre>

			===Modification et Suppression===

			<pre>
	// script de modification des champs "address"		// script de modification des champs "address"
	db.persons.find( { address: {$ne : null}}).forEach(		db.persons.find( { address: {$ne : null}}).forEach(

2014-10-28T08:30:59Z

Requêtes avancées

← Older revision		Revision as of 08:30, 28 October 2014
Line 188:		Line 188:
	==Requêtes avancées==		==Requêtes avancées==

			===Agrégation===
	<pre>		<pre>


	// ~~agregation~~ (type COUNT) par skill : see http://docs.mongodb.org/manual/tutorial/aggregation-with-user-preference-data/		// agrégation (type COUNT) par skill : see http://docs.mongodb.org/manual/tutorial/aggregation-with-user-preference-data/
	db.persons.aggregate(		db.persons.aggregate(
	[		[
Line 203:		Line 204:
	// agregation (type COUNT) par map-reduce : see http://docs.mongodb.org/manual/tutorial/map-reduce-examples/		// agregation (type COUNT) par map-reduce : see http://docs.mongodb.org/manual/tutorial/map-reduce-examples/

			</pre>

			===Agrégation par [[Map-Reduce]]===

			<pre>

	var mapFunction1 = function() {		var mapFunction1 = function() {

2014-10-28T08:26:20Z

Création et requêtes

← Older revision		Revision as of 08:26, 28 October 2014
Line 183:		Line 183:
	var p = db.persons.find()		var p = db.persons.find()
	while ( p.hasNext() ) printjson( p.next().lastname )		while ( p.hasNext() ) printjson( p.next().lastname )

			</pre>

			==Requêtes avancées==

			<pre>


	// agregation (type COUNT) par skill : see http://docs.mongodb.org/manual/tutorial/aggregation-with-user-preference-data/		// agregation (type COUNT) par skill : see http://docs.mongodb.org/manual/tutorial/aggregation-with-user-preference-data/

2014-10-28T06:42:00Z

Création et requêtes

← Older revision		Revision as of 06:42, 28 October 2014
Line 249:		Line 249:
	}		}
	)		)

			// suppression de persons de la collection

			db.persons.remove( { likes: { $exists: false } } )

	exit		exit

2014-10-28T06:35:38Z

Création et requêtes

@@ Line 121: / Line 121: @@
     skill : ["Software Engineering","OSGi","IoT"],
     hobbies: ["Laser cutter", "DIY"],
+}
+)
@@ Line 135: / Line 136: @@
     skill : ["Network","Grid"],
     hobbies: ["3D printing", "DIY"],
+}
+)
@@ Line 149: / Line 151: @@
     skill : ["Operating Systems","Phycomp","Network"],
     address: "Saint Martin d'Hères",
+}
+)
@@ Line 181: / Line 184: @@
 while ( p.hasNext() ) printjson( p.next().lastname )
-// agregation des skills : see http://docs.mongodb.org/manual/tutorial/aggregation-with-user-preference-data/
+// agregation (type COUNT) par skill : see http://docs.mongodb.org/manual/tutorial/aggregation-with-user-preference-data/
 db.persons.aggregate(
+  [
@@ Line 191: / Line 194: @@
+)
 // script de modification des champs "address"
@@ Line 205: / Line 252: @@
 exit
 </pre>
 <pre>