{"type":"doc","content":[{"type":"paragraph","content":[{"text":"A spatial engine provides access to a service that can perform spatial operations, such as determining what entities fall within a polygon; The spatial engine also provides a spatial perspective to the entities that the system will use. For example, providing details about the coordinate reference system that the entity is stored in.","type":"text"}]},{"type":"paragraph","content":[{"text":"The spatial engine will generally be something like ArcSDE, Oracle Spatial, Shapefiles or WFS, and usually at least one spatial engine will be defined.","type":"text"}]},{"type":"paragraph","content":[{"text":"Because there are different spatial engines available, there are different configuration parameters available for each one. Consequently, the content of a spatial engine tag will be different depending upon the actual spatial engine being used.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Namespace","type":"text"}]},{"type":"paragraph","content":[{"text":"urn:com.cohga.server.spatial.geotools#1.0","type":"text","marks":[{"type":"code"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Tags","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"spatialengine","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Properties","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":1800.0,"localId":"c33b8fa6-81b0-49eb-8982-904fd57f7d19"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Type","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Required","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"id","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"string","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"yes","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"unique identifier","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Sub-tags","type":"text"}]},{"type":"paragraph","content":[{"text":"Depends on type of spatial engine","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Content","type":"text"}]},{"type":"paragraph","content":[{"text":"Depends on type of spatial engine","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Resetting a spatial engine","type":"text"}]},{"type":"paragraph","content":[{"text":"The list of layers/tables available in a spatial engine are read when the spatial engine starts up and are cached for the lifetime of the spatial engine, which means that layers/tables added to the spatial engine after startup are not know to Weave.","type":"text"}]},{"type":"paragraph","content":[{"text":"To update the spatial engine after a layer/table has been added the spatial engine should be reset, prior to Weave version 2.6.9 this would have to be done by either making a small unimportant change to the spatial engine configuration (e.g. adding to the config, which would be ignored, but trigger Weave to restart the spatial engine) then saving the change, then reverting it and saving the file again, or commenting out the spatial engine configuration completely, saving the file, undoing the change and saving the file again. Both options would force Weave to reload the list of available tables. And, of course you could just restart the Weave server.","type":"text"}]},{"type":"paragraph","content":[{"text":"As of Weave version 2.6.9 there are two options to reset a spatial engine without having to edit the configuration. Firstly the ","type":"text"},{"text":"spmd","type":"text","marks":[{"type":"code"}]},{"text":" command has a new sub-command, ","type":"text"},{"text":"reset","type":"text","marks":[{"type":"code"}]},{"text":", which takes the name of the spatial engine to reset, e.g. ","type":"text"},{"text":"spmd reset opendata","type":"text","marks":[{"type":"code"}]},{"text":". The second option is a reset button in the Spatial Engine tool in the Admin UI where you can select the spatial engine from the list and click the reset button.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Examples","type":"text"}]},{"type":"paragraph","content":[{"text":"Connecting to ArcSDE","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\tarcsde\n\thostname\n\t5151\n\tusername\n\tpassword\n\t\n\t\t2\n\t\t5\n\t\t10000\n\t\ttrue\n\t\tfalse\n\t\tfalse\n\t\t5000\n\t\tblock\n\t\n","type":"text"}]},{"type":"paragraph","content":[{"text":"Connecting to Oracle Spatial","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\toracle\n\thostname\n\t1521\n\tusername\n\tpassword\n\tSCHEMA\n\tinstance\n","type":"text"}]},{"type":"paragraph","content":[{"text":"Connecting to Microsoft SQL Server","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\tsqlserver\n hostname\n 1433\n username\n password\n password\n SCHEMA\n v_geometry_columns\n","type":"text"}]},{"type":"paragraph","content":[{"text":"Connecting to Microsoft SQL Server using JNDI","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\tsqlserverjndi\n \n","type":"text"}]},{"type":"paragraph","content":[{"text":"Connecting to a Shapefile directory","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\tshapefiledir\n\t\n\ttrue\n","type":"text"}]},{"type":"paragraph","content":[{"text":"Connecting to WFS","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\twfs\n\t\n\tget\n\tusername\n\tpassword\n\t5000\n\t100000\n\ttrue\n\ttrue\n","type":"text"}]},{"type":"paragraph","content":[{"text":"Connecting to ArcGIS","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\tarcgis\n\thttps://services.arcgis.com/3vStCH7NDoBOZ5zn/arcgis/rest/services/Potable_Water_Pipe/FeatureServer\n\tEPSG:28356\n","type":"text"}]},{"type":"paragraph","content":[{"text":"Connecting to a GeoPackage","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\tgeopkg\n\t./platform/workspace/db/opendata.gpkg\n\n","type":"text"}]},{"type":"paragraph","content":[{"text":"Connecting to a GeoJSON file","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\tgeojson\n\t./platform/workspace/db/stadiums.geojson\n","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph"}],"version":1}