POST
|
That is the sixty four thousand dollar question! Can't really tell. Probably null, but maybe not. Yeah, I can't yet figure out how to use the code block and Insert Values field in tandem with one another...off to yootoob!
... View more
11-02-2018
11:33 AM
|
0
|
3
|
1445
|
POST
|
Thanks Joe! That's on the right track- I think I have to put together a little codeblock to handle the empty/null fields though. It bombs out trying to convert a nothing into an INT.
... View more
11-02-2018
10:52 AM
|
0
|
5
|
711
|
POST
|
Yeah, there's probably gonna be a few oddities like this. But on the bright side, the Points field appended properly!! First try (because it seems to be easiest!) is to copy the text fields into long fields. Exacerbating this issue is the switch to ArcGIS pro- mostly all the help articles I've found show how to do things in ArcMap. I could probably just go back to ArcMap to massage my input data, but I think it's probably better to bite the bullet now and figure it out in Pro so I have a good documented process for two years from now when someone has to do this again and ArcMap is no longer available. For example, the article I found says to create new fields and copy. But they give a VB example and, of course, that's no longer around in Pro. So I have to figure out the equivalent in Python, SQL, or Arcade (whatever the heck THAT is!!!)
... View more
11-02-2018
09:35 AM
|
0
|
1
|
711
|
POST
|
I believe I just want to change whitespace " " to nulls. Will Select By Attribute allow me to select by column instead of rows? There are other columns that have legitimate space characters. As Michael knows from my "main" thread for my task, I'm an ArcGIS newbie with some limited python knowledge, so I'm slowly feeling my way through to get run books created for my fire company. Also as Michael points out, I may have a data type mismatch- not sure which situation is occurring. I guess I should try one "fix" at a time so I can figure out what exactly the culprit is, as this will be an annual/biennial process....
... View more
11-02-2018
07:53 AM
|
0
|
0
|
1619
|
POST
|
Hmmm, good point- the source table lists as TEXT. So I wonder if the failure is on a Space character (as the 001156 text says " ") or on the datatype. Or maybe both. So maybe I have to somehow convert the entire column to long integer and any spaces will take care of themselves during that operation???
... View more
11-02-2018
07:47 AM
|
0
|
1
|
1619
|
POST
|
Looks like I have some whitespace instead of nullls. Looked thru all the rows and the ones that aren't blank are numeric (plus the error text points to " "). The target field is long integer with ISNULLABLE set to true. Working on finding a way to use the field calculator to change whitespace to nulls- I asked a question over in the "Managing Data" forum to save you guys the tedium (and to save this thread from drifting too far of the course of what's required for the Fire Maps). Will report back!!
... View more
11-02-2018
07:41 AM
|
0
|
4
|
711
|
POST
|
ArcGIS PRO 2.2: How to change spaces to Nulls? Hi all, running a canned project "Fire ServiceMaps" in which a task wants me to append my Street Centerlines file into the LocalGovernment model. The target field is defined as a long integer that accepts null values. However, it looks like my input file has some spaces in it so the append fails with ERROR 001156. I searched around trying to find a way to convert the spaces in my source to NULL values, but nothing I could get to work. What is the best/easiest ways to search a column for blanks and replace with NULL in Pro 2.2? Thanks.
... View more
11-02-2018
07:04 AM
|
0
|
5
|
1846
|
POST
|
To restate the obvious, yes, Mike, you were dead on . Importing the feature class is (now I know this!) equivalent to importing the shapefile. So all the way back to square 1 I went, almost- running feature-to-point and importing that feature class back to the SiteAddressPoint. But think of everything I learned because of my mistaken assumptions!!! So now on to step 2, and running into another puzzler. Importing the StreetCenterlines. Same drill, change he shapefile into a feature class, then append that onto the RoadCenterlines feature class of the target dataset. Matched all the input fields to the output fields, but the append is failing with "Error 0001156: Failed on Input OID 1, could not write value ' ' to output field FROMLEFT". The FROMLEFT, of course, is the "Lowest address range on the left side of the road" which is mapped to my input field L_F_ADD. And the schema says "IsNullable" is TRUE, so I don't need any value there (which makes sense). I wonder if there may be a space character in here that it's choking on? Would be a tough one to find and remedy. I did look into the ETL from ActMap, and apparently my license doesn't allow that, so it's a non-starter. After this fromleft challenge, my next one will be to create a feature class to demarcate my FireDistrict. I thought I could skip that one, but well, I think that's how the utility knows exactly how to pare down the whole map and just draw the necessary pages. This will simply be my entire municipality (township). I think I'm going to try to use the "PA Municipality Boundaries" tool and then see if I can somehow cut it down to just my township. That will be another learning experience. I guess I just can't go in and edit the table of the feature class and remove everything else? I don't know yet. Oh yeah, and figure out what it's asking for with the "FireIMapndex" inport data. Til tomorrow... Thanks guys for all your help!!!
... View more
11-01-2018
07:25 PM
|
0
|
6
|
711
|
POST
|
AAARRRGGGHHHH I thought I had it. When selecting the shapefile as input fo the append, it gives me an error for a table mismatch or something like that. Looks like I have to convert it to a feature class in a gdb first. Back to my homework assignments!!!
... View more
11-01-2018
06:15 PM
|
0
|
0
|
711
|
POST
|
WAIT A DANG MINUTE! I think I see it now. I can actually import my parcels SHAPEFILE right into the project- I don't go through the conniption FIRST of creating the centroids- I'll do that once my project is all loaded up. So yes, Michael, you are correct- it actually doesn't have to be in the target Feature Class if I have the shapefile in my project. I threw myself off by creating the points FIRST! This hit me when I was doing step 2 (Street Centerlines) because I was thinking "wait, that doesn't have any spatial reference either! And I finally clicked on the help button on the task explaining what append does and it says plain and simple "Appends multiple input datasets into an existing target dataset. Input datasets can be feature classes, tables, shapefiles, rasters, annotation or dimensions feature classes." And when I saw "shapefiles" that's when the bell went off. And whaddaya know- that's also step 3 of my homework for tonight! So it looks like Joe's homework is entirely relevant- I will be ditching shapefiles in lieu of a geodatabase and feature classes- but I can't ditch them until *after* in import them! Onward and upward...now I gotta figure out the tedium of merging fields in my input schema to match the LGIM! Thanks guys!
... View more
11-01-2018
04:02 PM
|
0
|
0
|
744
|
POST
|
OK, sorry about the brief response- was on the road. Now that I'm back in front of a real screen, here's what I tried to make sure that the points tied back to my shapefile to actually have some real spatial reference: -Opened the project with my parcel polygons and SiteAdressPoints already in it -As per the instructions here, I went to Open-->Portal-->and double clicked Fire ServiceMaps.ppkx from "My Content" (I had already "Deployed the solution" to my organization as per the instructions here). -I then get a prompt to "Save Changes to <current project with polygons & address points>?" -I click "Yes", and then it closes my prior project and opens a new win (of course starting from scratch). So If I don't have those geometry points in my new project, how will it know? I had assumed that the class in the prior project (created from FeatureToPoint) pointed back to the shapefile- that's how it knows where to put the points. But obviously I really do not know the mechanics of it all. I'm sure that other people who have deployed the maps have seen the same thing (unless it's always skipped?) I considered just skipping it and adding the layer independently. But if the SiteAddressPoints data is useless, why are they even asking for it? There's got to be something I'm missing....
... View more
11-01-2018
03:02 PM
|
0
|
0
|
744
|
POST
|
The way this is structured, I have to create a new project to launch the "Fire Service Maps" tasks. Then on the the data import task to populate SiteAddresdPoints I designate as the input dataset the feature class which I created in a separate, independent project. I actually did try to use the same project but couldn't figure out how to load in the Maps template other than by following their instructions - which of course called for a fresh project...
... View more
11-01-2018
01:14 PM
|
0
|
0
|
744
|
POST
|
Yep, that's what I was trying to do..I thought I was all kinds of crafty finding the tool to extract the coordinates of the point data into the table I created from Feature-To-Point. However, the target table SiteAddressPoint has no place for me to map the coordinates to! I'm still really perplexed as to how the map is supposed to know where the points are with no coordinates of any sort. I thought that USNGCOORD would be it, but as Joe points out that's just a grid system and not an exact point. I can't figure out anything that maps to the coordinates!! Here's the schema: https://solutions.arcgis.com/local-government/help/local-government-information-model/get-started/DataDictionary/DataDic… I misspoke a little bit earlier: That SiteAddressTable is actually The first of 5 steps of the 2nd task, "Load Your Source Data". The five target tables I need to populate: 1- SiteAddressPoint 2. RoadCenterlines (working on that mapping now, looks like all the important stuff can be lined up) 3. FireResponseRestrictPoint (which is road restrictions, like low bridges, gates, etc.- I will skip this for now) 4. FireMapIndex (I really can't figure out what this is or what data it needs yet) 5. FireDistrict (Looks like it's boundaries for different fire districts- I will likely skip that as well, as I'm only doing our district). So I'm moving on with #2 for now and once I have identified the proper mappings I'll go back to #1. Maybe I'll have an epiphany in the meantime!!!
... View more
11-01-2018
11:37 AM
|
0
|
0
|
744
|
POST
|
11-01-2018
11:18 AM
|
0
|
0
|
744
|
POST
|
Nothing yet...but I only emailed them this morning. Yes, I'm hoping that they adopted the stock LGIM, but not too optimistic. Hopefully if they DO have something they won't make me/us pay again. The county GIS has a fee schedule- a set price per parcel and then an hourly for 'custom' work. Not too bad; ending up costing us like $250 for the 6,906 parcels in our township.
... View more
11-01-2018
10:27 AM
|
0
|
4
|
744
|
Title | Kudos | Posted |
---|---|---|
1 | 11-01-2018 06:23 AM | |
1 | 11-05-2018 06:14 PM | |
1 | 11-06-2018 08:31 AM | |
1 | 11-05-2018 04:53 PM | |
1 | 11-08-2018 03:17 PM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:25 AM
|