Latest Contributions by RiyasDeen

Hi Stephen, Feature service is returning date in UTC() format. http://services.arcgis.com/V6ZHFr6zdgNZuVG0/ArcGIS/rest/services/U2/FeatureServer/0//query?where=1%3D1&objectIds=&time=&…‌ Try below: String.Format("\"attributes\":{{\"fid\":\"0114081403\",\"start_time\": {0}}}", record_date.Subtract(new DateTime(1970,1,1,0,0,0)).Milliseconds ) ... View more

Hi Ia, From what I'm seeing here, i would expect your code to work. Forget about the marker symbol, Are you able to at least see your base map with the points from layer Congtrinh. ? ... View more

Hi Ia, Are you able to render your point layer now? ... View more

Correction: If the response of above URL contains Tile Info then your map service is not a tiled map service. ... View more

Hi Kristin, This is from ArcMap 10.2 Right click your layer after selecting your features --> Open Attribute table --> Right click on the column header you want to summarize on (In your case this will be municipality field, you'll need a common attribute value to summarize on) --> Select Summarize. Check Summarize on the selected records only option. You should have what you want. ... View more

Hi David, Assuming you have a common primary field in your FGDB and SDE Feature Class. Iterate through FGDB FC (A) and SDE FC (B), and create two lists of primary fields. A - B, will give list of additions in FGDB (Use Insert cursor to insert features to SDE) B - A will give list of deletions in SDE (Delete features from SDE) Use Geometry equals, if you want to compare geometry and update SDE geometry. Reference links: List Difference - Python, compute list difference - Stack Overflow‌ Insert Cursor - ArcGIS Help 10.1‌http://resources.arcgis.com/en/help/main/10.1/index.html#//018w0000000t000000 Update Cursor - ArcGIS Help 10.1‌ Geometry Equals - ArcGIS Help 10.1‌ Hope this helps. ... View more

Hi Naime, Is this what you are looking for ArcGIS Help 10.1‌ ? ... View more

Hi Graham, My knowledge on SQL Server is limited, so I'll try to answer your question in oracle and DB2 context. Oracle (non-RAC): In the case of oracle one instance can have one and only database at a time. When you create an oracle DB instance you specify SGA and PGA, essentially these are memory reservations for the database. These reserved memory are available only to this instance. You create another instance on the same server you need to reserve memory for that instance as well. Not all of this reserved memory is used by an instance all the time. Instance will use all of this memory at peak load, when you are most likely to see performance issues. If you have multiple instances on same server you will end up reserving memory for these instance overheads, which can be used for buffer pools which is one of the most important factor for DB performance. DB2: In the case of DB2 you can have one instance and multiple databases. You have memory reservation for the instance and memory reservation for each database. If you have multiple database you'll end up reserving some memory for each database which potentially goes unused (unless there is peak load) which can be used for buffer pool. When you store your vector and raster datasets in the same database, they are going to sit in different table spaces of their own. Table space and buffer pool are the most important factors for a DB performance. With above information in mind, If you have funds for one DB server (hardware + software + hosting + support), you are better off having one database for storing both your vector and raster datasets. As long as you tune your database as good as possible, which is essentially maximum utilisation of your disk IO and system memory. If you have sufficient fund storing them in two physical server is ideal. I have discussed some advanced DBA topic above, so it is important for you to know that I'm primarily a developer (with exposure to database management) and not a professional DBA. ... View more

Hi Graham, There is no one correct answer for this. I'm sure there are going to be multiple views, I'll put my view here. Definitely I would't recommend using multiple databases, particularly if you are building an enterprise system. If you have multiple databases you are multiplying your maintenance cost. It's going to be difficult to integrate your spatial data across database like creating spatial views. Having multiple schema within same database is a good option, particularly if you want to segregate your data logically and have access control at DB tier. One important thing to consider when you are building an enterprise geodatabase is making wise use of dbtune file, never use the default dbtune file, create your own dbtune file with configuration keywords specific for feature classes, particularly helpful in storing feature classes in separate table spaces. This way you can provide a bigger buffer pool for frequently used feature classes. Follow the best practices recommended by the database vendor as you would build a normal database, putting it simply geodatabase is nothing but a database with a spatial column and object id managed by ArcSDE. ... View more

Hi Ia, If you notice the sample you referred, base map is created from a tiled map service but the FeatureLayer is created from a feature service. In your case you are creating the base map and feature layer from the same map service. ... View more