Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About ZachBodenner
ZachBodenner
MVP Regular Contributor
since
06-18-2019
Online
416
Posts created
23
Kudos given
28
Solutions
206
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(5 Idea Submissions)Latest Contributions by ZachBodenner
|
POST
|
Hello, I am having this same issue - same ItemID and everything! When I set up the survey in Connect, I use a custom basemap as the default that is shared publicly, with all items therein shared publicly as well. In my Portal (11.1), I can navigate to the item id showing the sign in request but it is definitely not in my map anywhere. Here's a screenshot of the map layers via AGO Assistant: Any ideas why it would be prompting sign in for a layer that isn't there?
... View more
Wednesday
|
0
|
0
|
9
|
|
POST
|
Alright so I've been trying to tweak this and I think that these changes should catch all possibilities, correct? So in both ss c) and ss d) have one of two possibilities in the IF statement, either the count is greater than zero, or it is zero. Again, the code continues to work fine in map viewer, but throws an error when opening the popup in Field Maps. // ESTABLISH PARCEL PID AND AREA INFO//
var parcelPID = $feature.PID
var parentPID = $feature.Parent_PID
var acres = Text($feature.ACRES,'#,###.##')
var sqft = Text($feature.AREA_SQFT,'#,###')
var properAddress = $feature.ADDRESS
// PLAT LINK //
var platLink = $feature.Plat_No_Link;
var platName = $feature.PlatName;
var pl = `<a href="${platLink}" target="_blank"><span style="color:#295e8f;">${PlatName}</span></a>`
// WATERSHED DISTRICT //
// convert numbers to WSD names and finish
var watershed = $feature.Watershed;
var wsd = decode(watershed, '04', "Riley-Purgatory-Bluff Creek WSD", '01', "Nine Mile Creek WSD", "Minnesota River WSD")
console (wsd)
// ZONING //
/* One of two situations can occur when trying to match a parcel to a zoning district polygon.
A) The PID of the parcel matches the PID of a zoning polygon exactly (in this case, the zoning district poly is just a parcel)
B) The PID does not match (in this case, the parcel polygon is one of many on a zoning parcel, or viceversa, and there are many zoning polygons touching the parcel)
If A) we will run a filter where the PID of the zoning parcel matches this parcel's PID (see subsection a))
If B) we will run a filter where the PID of the zoning parcel matches this parcel's Parent PID (see subsection b))
*/
// Zoning Variables
var zoningLayer = FeatureSetByName($map, "Zoning",['PID','ZONING','TAZ']);
//variable used in html return
var z = ''
// first zoining district, used in subsection c) to determine the color of the header
var fZd = ''
// ss a)
// run the filter and determine how many matches there are
var zdFilter = Filter(zoningLayer, 'PID=@parcelPID');
var cZDF = count(zdFilter)
console ("Count of items passing zdFilter: "+cZDF)
// ss b)
// run the intersect and determine how many matches there are
var zdParent = Filter(zoningLayer, 'PID=@parentPID')
var cZDP = count(zdParent)
console ("Count of items passing zdParent: "+cZDP)
// ss c)
// Determine the color of the header by figuring out if a single zoning polygon matches a parcel PID. If no match, attempt to match Parent PID
if (cZDF >0)
{ fZd = first(zdFilter)}
if (cZDF == 0)
{ fZd = first(zdParent)}
var zColor = decode(fZd.ZONING, "RURAL","#FDE8BD","R1-44","#D1AB7B","R1-22","#A06632","R1-13.5","#FFFF00","R1-9.5","#E0B700","RM-6.5","#E09300","RM-2.5","#b58151","OFC","#F9C2FE","N-COM","#FEB3B3","C-COM","#FE8181","C-HWY","#FF00FF","C-REG-SER","#FF4040","C-REG","#c47243","TC-C","#F57A7Al","TC-R","#CD6666","TC-MU","#CD6666","I-2","#D1BDFE","I-5","#B579F4","I-GEN","#864AFE","PUB","#8FBC8F","GC","#D3FFBE","Water","#A4F9FE","RIGHT-OF-WAY","#D2D2D2","#D2D2D2")
// ss d)
// determine what will appear in the table. We want to privilege the main PID because that means there's an exact match between the parcels and the zoning. So, if ANY features pass the filter, we will use them here
if (cZDF >0){
for (var zoningPIDs in zdFilter)
{
// Set links to EP Municode
var zl = decode(zoningPIDs.ZONING,"RURAL","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.10URDI","R1-44","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.11ONFAREDI","R1-22","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.11ONFAREDI","R1-13.5","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.11ONFAREDI","R1-9.5","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.11ONFAREDI","RM-6.5","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.15RMMUMIREDI","RM-2.5","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.15RMMUMIREDI","OFC","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.20OFFFDI","N-COM","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.25OMDI","C-COM","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.25OMDI","C-HWY","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.25OMDI","C-REG-SER","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.25OMDI","C-REG","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.25OMDI","TC-C","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.27TCTOCEDI","TC-R","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.27TCTOCEDI","TC-MU","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.27TCTOCEDI","I-2","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.30NDDI","I-5","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.30NDDI","I-GEN","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.30NDDI","PUB","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.35PUUB","GC","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.36LFCO","Water","","RIGHT-OF-WAY","","Please Call City 952-949-8485","",'')
// Final zoning description (convert code to readable text)
var zd = decode(zoningPIDs.ZONING, "RURAL","Rural","R1-44","R1-44: One Family- 44,000 sf. min.","R1-22","R1-22: One Family-22,000 sf min.","R1-13.5","R1-13.5: One Family-13,500 sf min.","R1-9.5","R1-9.5: One Family-9,500 sf min.","RM-6.5","RM-6.5: Multi-Family-6.7 U.P.A. max.","RM-2.5","RM-2.5: Multi-Family-17.4 U.P.A. max.","OFC","Office","N-COM","Neighborhood Commercial","C-COM","Community Commercial","C-HWY","Highway Commercial","C-REG-SER","Regional Service Commercial","C-REG","Regional Commercial","TC-C","Town Center - Commercial","TC-R","Town Center - Residential","TC-MU","Town Center - Mixed Use","I-2","Industrial Park - 2 Acre Min.","I-5","Industrial Park - 5 Acre Min.","I-GEN","General Industrial - 5 Acre Min.","PUB","Public","GC","Golf Course","Water","Water","RIGHT-OF-WAY","Right-of-Way","Please Call City 952-949-8485","Right-of-Way","")
console("zoning districts match PIDs: "+zd)
var zoneList = `<span style="color:#295e8f;">${zd}</span>`+'\n'
z += Trim(`<a href="${zl}" target="_blank"><span style="color:#295e8f;">${zoneList}</span></a>`)
}
}
//but if there is not a match with the current PIDs, we will use the parent PID which is the number of the parcel before subdivision.
if (cZDF == 0) {
for (var zoningPIDs in zdParent)
{
// Set links
var zl = decode(zoningPIDs.ZONING,"RURAL","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.10URDI","R1-44","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.11ONFAREDI","R1-22","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.11ONFAREDI","R1-13.5","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.11ONFAREDI","R1-9.5","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.11ONFAREDI","RM-6.5","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.15RMMUMIREDI","RM-2.5","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.15RMMUMIREDI","OFC","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.20OFFFDI","N-COM","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.25OMDI","C-COM","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.25OMDI","C-HWY","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.25OMDI","C-REG-SER","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.25OMDI","C-REG","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.25OMDI","TC-C","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.27TCTOCEDI","TC-R","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.27TCTOCEDI","TC-MU","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.27TCTOCEDI","I-2","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.30NDDI","I-5","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.30NDDI","I-GEN","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.30NDDI","PUB","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.35PUUB","GC","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.36LFCO","Water","","RIGHT-OF-WAY","","Please Call City 952-949-8485","",'')
// Final zoning description
var zd = decode(zoningPIDs.ZONING, "RURAL","Rural","R1-44","R1-44: One Family- 44,000 sf. min.","R1-22","R1-22: One Family-22,000 sf min.","R1-13.5","R1-13.5: One Family-13,500 sf min.","R1-9.5","R1-9.5: One Family-9,500 sf min.","RM-6.5","RM-6.5: Multi-Family-6.7 U.P.A. max.","RM-2.5","RM-2.5: Multi-Family-17.4 U.P.A. max.","OFC","Office","N-COM","Neighborhood Commercial","C-COM","Community Commercial","C-HWY","Highway Commercial","C-REG-SER","Regional Service Commercial","C-REG","Regional Commercial","TC-C","Town Center - Commercial","TC-R","Town Center - Residential","TC-MU","Town Center - Mixed Use","I-2","Industrial Park - 2 Acre Min.","I-5","Industrial Park - 5 Acre Min.","I-GEN","General Industrial - 5 Acre Min.","PUB","Public","GC","Golf Course","Water","Water","RIGHT-OF-WAY","Right-of-Way","Please Call City 952-949-8485","Right-of-Way","")
console("Zoning District match parent PIDs: "+zd)
var zoneList = `<span style="color:#295e8f;">${zd}</span>`+'\n'
z += Trim(`<a href="${zl}" target="_blank"><span style="color:#295e8f;">${zoneList}</span></a>`)
}
}
// ss e)
// Set popup section title color Note: this is a workaround because div colors for text do not work in the arcade return.
var title = `<span style="color:#000">Parcel Information - ${properAddress}</span>`
return {
type : 'text',
text : `<div style="color:#ffffff;font-size:16px;background-color:${zColor};padding:5px;">
<span style><strong>${title}</strong></span>
</div>
<table style="width:100%">
<tbody>
<tr>
<td style="width:40%;padding-left:2%">
<span><strong>PID</strong></span>
</td>
<td style="width:60%;padding-left:2%">
<span>${parcelPID}</span>
</td>
</tr>
<tr>
<td style="background-color:#e1e1e1;padding-left:2%">
<span><strong>Address</strong></span>
</td>
<td style="background-color:#e1e1e1;padding-left:2%">
<span>${properAddress}</span>
</td>
</tr>
<tr>
<td style="padding-left:2%">
<span><strong>Area (Sq.Ft.)</strong></span>
</td>
<td style="padding-left:2%">
<span>${sqft}</span>
</td>
</tr>
<tr>
<td style="background-color:#e1e1e1;padding-left:2%">
<span><strong>Acres</strong></span>
</td>
<td style="background-color:#e1e1e1;padding-left:2%">
<span>${acres}</span>
</td>
</tr>
<tr>
<td style="padding-left:2%">
<span><strong>Addition Name</strong></span>
</td>
<td style="padding-left:2%">
<span>${pl}</span>
</td>
</tr>
<tr>
<td style="background-color:#e1e1e1;padding-left:2%">
<span><strong>Lot</strong></span>
</td>
<td style="background-color:#e1e1e1;padding-left:2%">
<span>${$feature.Lot}</span>
</td>
</tr>
<tr>
<td style="padding-left:2%">
<span><strong>Block</strong></span>
</td>
<td style="padding-left:2%">
<span>${$feature.Block}</span>
</td>
</tr>
<tr>
<td style="background-color:#e1e1e1;padding-left:2%">
<span><strong>Watershed District</strong></span>
</td>
<td style="background-color:#e1e1e1;padding-left:2%">
<span>${wsd}</span>
</td>
</tr>
<tr>
<td style="padding-left:2%">
<span><strong>Zoning</strong></span>
</td>
<td style="padding-left:2%">
<span>${z}</span>
</td>
</tr>
</tbody>
</table>
`
}
... View more
|
0
|
0
|
31
|
|
POST
|
Ah I see what you're saying, no it looks like you have it set up correctly. Here's mine: I've done mine in local FGDBs and also our primary Enterprise Geodatabase. Nothing online. When you say you're doing it in a related table, are you trying to migrate an entire parent AND child dataset (ie. feature class and related table)? Whether it's a table or a feature class shouldn't make a difference.
... View more
a week ago
|
0
|
1
|
26
|
|
POST
|
I will definitely give that a try, though I wonder if you know why Field Maps would have a tough time with it when the map viewer does not?
... View more
a week ago
|
0
|
0
|
76
|
|
POST
|
Hello, I am building an Arcade expression that I am overall quite happy with. Essentially, it will display information from a feature (parcels) and also pull information from a second layer (zoning) based on matching up PIDs. The complication is that the polygons of the zoning layer don't necessarily match the parcel layer. For example, if a parcel gets subdivided, the polygon on the zoning layer will often stay the same shape as it was pre-division. The resulting split parcels will have new PIDs, and a value in the attribute "Parent PID" that matches the original pre-division parcel. So in order to correctly match the parcel to the zoning polygon, I need to check both attributes. I start with PID, and if that fails, I check Parent PID. But I'm running into a strange problem: this works great in map viewer and the resulting Experience Builder app, but when I open this in Field Maps, I get an error message that simply says: "Unable to Load All Data Some expressions failed to evaluate." Sharing the error shows an error code 400, Unable to complete operation. I don't know exactly why this would be other than that based on my testing it has something to do with the // ZONING // section. I commented it all out and then was able to view the remainder in Field Maps successfully. Is there something in this code that would work in Map Viewer but not Field Maps? The code below is very long but I didn't want to abbreviate it in case there's something that I just don't know to look for. // ESTABLISH PARCEL PID AND AREA INFO//
var parcelPID = $feature.PID
var parentPID = $feature.Parent_PID
var acres = Text($feature.ACRES,'#,###.##')
var sqft = Text($feature.AREA_SQFT,'#,###')
var properAddress = $feature.ADDRESS
// PLAT LINK //
var platLink = $feature.Plat_No_Link;
var platName = $feature.PlatName;
var pl = `<a href="${platLink}" target="_blank"><span style="color:#295e8f;">${PlatName}</span></a>`
// WATERSHED DISTRICT //
// convert numbers to WSD names and finish
var watershed = $feature.Watershed;
var wsd = decode(watershed, '04', "Riley-Purgatory-Bluff Creek WSD", '01', "Nine Mile Creek WSD", "Minnesota River WSD")
console (wsd)
// ZONING //
/* One of two situations can occur when trying to match a parcel to a zoning district polygon.
A) The PID of the parcel matches the PID of a zoning polygon exactly (in this case, the zoning district poly is just a parcel)
B) The PID does not match (in this case, the parcel polygon is one of many on a zoning parcel, or viceversa, and there are many zoning polygons touching the parcel)
If A) we will run a filter where the PID of the zoning parcel matches this parcel's PID (see subsection a))
If B) we will run a filter where the PID of the zoning parcel matches this parcel's Parent PID (see subsection b))
*/
// Zoning Variables
var zoningLayer = FeatureSetByName($map, "Zoning",['PID','ZONING','TAZ']);
//variable used in html return
var z = ''
// first zoining district, used in subsection c) to determine the color of the header
var fZd = ''
// ss a)
// run the filter and determine how many matches there are
var zdFilter = Filter(zoningLayer, 'PID=@parcelPID');
var cZDF = count(zdFilter)
console ("Count of items passing zdFilter: "+cZDF)
// ss b)
// run the intersect and determine how many matches there are
var zdParent = Filter(zoningLayer, 'PID=@parentPID')
var cZDP = count(zdParent)
console ("Count of items passing zdParent: "+cZDP)
// ss c)
// Determine the color of the header by figuring out if a single zoning polygon matches a parcel PID. If no match, attempt to match Parent PID
if (cZDF ==1)
{ fZd = first(zdFilter)}
else
{ fZd = first(zdParent)}
var zColor = decode(fZd.ZONING, "RURAL","#FDE8BD","R1-44","#D1AB7B","R1-22","#A06632","R1-13.5","#FFFF00","R1-9.5","#E0B700","RM-6.5","#E09300","RM-2.5","#b58151","OFC","#F9C2FE","N-COM","#FEB3B3","C-COM","#FE8181","C-HWY","#FF00FF","C-REG-SER","#FF4040","C-REG","#c47243","TC-C","#F57A7Al","TC-R","#CD6666","TC-MU","#CD6666","I-2","#D1BDFE","I-5","#B579F4","I-GEN","#864AFE","PUB","#8FBC8F","GC","#D3FFBE","Water","#A4F9FE","RIGHT-OF-WAY","#D2D2D2","#D2D2D2")
// ss d)
// determine what will appear in the table. We want to privilege the main PID because that means there's an exact match between the parcels and the zoning. So, if ANY features pass the filter, we will use them here
if (cZDF ==1){
for (var zoningPIDs in zdFilter)
{
// Set links to EP Municode
var zl = decode(zoningPIDs.ZONING,"RURAL","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.10URDI","R1-44","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.11ONFAREDI","R1-22","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.11ONFAREDI","R1-13.5","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.11ONFAREDI","R1-9.5","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.11ONFAREDI","RM-6.5","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.15RMMUMIREDI","RM-2.5","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.15RMMUMIREDI","OFC","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.20OFFFDI","N-COM","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.25OMDI","C-COM","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.25OMDI","C-HWY","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.25OMDI","C-REG-SER","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.25OMDI","C-REG","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.25OMDI","TC-C","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.27TCTOCEDI","TC-R","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.27TCTOCEDI","TC-MU","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.27TCTOCEDI","I-2","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.30NDDI","I-5","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.30NDDI","I-GEN","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.30NDDI","PUB","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.35PUUB","GC","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.36LFCO","Water","","RIGHT-OF-WAY","","Please Call City 952-949-8485","",'')
// Final zoning description (convert code to readable text)
var zd = decode(zoningPIDs.ZONING, "RURAL","Rural","R1-44","R1-44: One Family- 44,000 sf. min.","R1-22","R1-22: One Family-22,000 sf min.","R1-13.5","R1-13.5: One Family-13,500 sf min.","R1-9.5","R1-9.5: One Family-9,500 sf min.","RM-6.5","RM-6.5: Multi-Family-6.7 U.P.A. max.","RM-2.5","RM-2.5: Multi-Family-17.4 U.P.A. max.","OFC","Office","N-COM","Neighborhood Commercial","C-COM","Community Commercial","C-HWY","Highway Commercial","C-REG-SER","Regional Service Commercial","C-REG","Regional Commercial","TC-C","Town Center - Commercial","TC-R","Town Center - Residential","TC-MU","Town Center - Mixed Use","I-2","Industrial Park - 2 Acre Min.","I-5","Industrial Park - 5 Acre Min.","I-GEN","General Industrial - 5 Acre Min.","PUB","Public","GC","Golf Course","Water","Water","RIGHT-OF-WAY","Right-of-Way","Please Call City 952-949-8485","Right-of-Way","")
console("zoning districts match PIDs: "+zd)
var zoneList = `<span style="color:#295e8f;">${zd}</span>`+'\n'
z += Trim(`<a href="${zl}" target="_blank"><span style="color:#295e8f;">${zoneList}</span></a>`)
}
}
//but if there is not a match with the current PIDs, we will use the parent PID which is the number of the parcel before subdivision.
else {
for (var zoningPIDs in zdParent)
{
// Set links
var zl = decode(zoningPIDs.ZONING,"RURAL","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.10URDI","R1-44","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.11ONFAREDI","R1-22","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.11ONFAREDI","R1-13.5","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.11ONFAREDI","R1-9.5","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.11ONFAREDI","RM-6.5","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.15RMMUMIREDI","RM-2.5","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.15RMMUMIREDI","OFC","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.20OFFFDI","N-COM","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.25OMDI","C-COM","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.25OMDI","C-HWY","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.25OMDI","C-REG-SER","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.25OMDI","C-REG","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.25OMDI","TC-C","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.27TCTOCEDI","TC-R","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.27TCTOCEDI","TC-MU","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.27TCTOCEDI","I-2","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.30NDDI","I-5","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.30NDDI","I-GEN","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.30NDDI","PUB","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.35PUUB","GC","https://library.municode.com/mn/eden_prairie/codes/code_of_ordinances?nodeId=CH11LAUSREZO_S11.36LFCO","Water","","RIGHT-OF-WAY","","Please Call City 952-949-8485","",'')
// Final zoning description
var zd = decode(zoningPIDs.ZONING, "RURAL","Rural","R1-44","R1-44: One Family- 44,000 sf. min.","R1-22","R1-22: One Family-22,000 sf min.","R1-13.5","R1-13.5: One Family-13,500 sf min.","R1-9.5","R1-9.5: One Family-9,500 sf min.","RM-6.5","RM-6.5: Multi-Family-6.7 U.P.A. max.","RM-2.5","RM-2.5: Multi-Family-17.4 U.P.A. max.","OFC","Office","N-COM","Neighborhood Commercial","C-COM","Community Commercial","C-HWY","Highway Commercial","C-REG-SER","Regional Service Commercial","C-REG","Regional Commercial","TC-C","Town Center - Commercial","TC-R","Town Center - Residential","TC-MU","Town Center - Mixed Use","I-2","Industrial Park - 2 Acre Min.","I-5","Industrial Park - 5 Acre Min.","I-GEN","General Industrial - 5 Acre Min.","PUB","Public","GC","Golf Course","Water","Water","RIGHT-OF-WAY","Right-of-Way","Please Call City 952-949-8485","Right-of-Way","")
console("Zoning District match parent PIDs: "+zd)
var zoneList = `<span style="color:#295e8f;">${zd}</span>`+'\n'
z += Trim(`<a href="${zl}" target="_blank"><span style="color:#295e8f;">${zoneList}</span></a>`)
}
}
// ss e)
// Set popup section title color Note: this is a workaround because div colors for text do not work in the arcade return.
var title = `<span style="color:#000">Parcel Information - ${properAddress}</span>`
return {
type : 'text',
text : `<div style="color:#ffffff;font-size:16px;background-color:${zColor};padding:5px;">
<span style><strong>${title}</strong></span>
</div>
<table style="width:100%">
<tbody>
<tr>
<td style="width:40%;padding-left:2%">
<span><strong>PID</strong></span>
</td>
<td style="width:60%;padding-left:2%">
<span>${parcelPID}</span>
</td>
</tr>
<tr>
<td style="background-color:#e1e1e1;padding-left:2%">
<span><strong>Address</strong></span>
</td>
<td style="background-color:#e1e1e1;padding-left:2%">
<span>${properAddress}</span>
</td>
</tr>
<tr>
<td style="padding-left:2%">
<span><strong>Area (Sq.Ft.)</strong></span>
</td>
<td style="padding-left:2%">
<span>${sqft}</span>
</td>
</tr>
<tr>
<td style="background-color:#e1e1e1;padding-left:2%">
<span><strong>Acres</strong></span>
</td>
<td style="background-color:#e1e1e1;padding-left:2%">
<span>${acres}</span>
</td>
</tr>
<tr>
<td style="padding-left:2%">
<span><strong>Addition Name</strong></span>
</td>
<td style="padding-left:2%">
<span>${pl}</span>
</td>
</tr>
<tr>
<td style="background-color:#e1e1e1;padding-left:2%">
<span><strong>Lot</strong></span>
</td>
<td style="background-color:#e1e1e1;padding-left:2%">
<span>${$feature.Lot}</span>
</td>
</tr>
<tr>
<td style="padding-left:2%">
<span><strong>Block</strong></span>
</td>
<td style="padding-left:2%">
<span>${$feature.Block}</span>
</td>
</tr>
<tr>
<td style="background-color:#e1e1e1;padding-left:2%">
<span><strong>Watershed District</strong></span>
</td>
<td style="background-color:#e1e1e1;padding-left:2%">
<span>${wsd}</span>
</td>
</tr>
<tr>
<td style="padding-left:2%">
<span><strong>Zoning</strong></span>
</td>
<td style="padding-left:2%">
<span>${z}</span>
</td>
</tr>
</tbody>
</table>
`
}
... View more
a week ago
|
0
|
3
|
91
|
|
POST
|
You could try a When statement like var AID = $feature.AssetID
var DIA = $feature.diameter
var Wid = $feature.width
When(AID != null, 'X', DIA != null && WID == null, 'Y', DIA != null && WID == 'UNKNOWN', 'Y', '') Admittedly, Arcade labeling can feel really limited and I don't actually know if this will work.
... View more
a week ago
|
0
|
1
|
91
|
|
POST
|
Yes, that is indeed cumbersome but with one minor tweak it does in fact work: if(string-length(pulldata("@layer", "getValueAt", "attributes.ADDRESS", "https://gis.edenprairie.org/maps/rest/services/Public/Parcels/MapServer/0", ${EP311_point})>0),'No Address Found',pulldata("@layer", "getValueAt", "attributes.ADDRESS", "https://gis.edenprairie.org/maps/rest/services/Public/Parcels/MapServer/0", ${EP311_point})) For some reason the empty quotes didn't get it done, but comparing against the return string length did the trick.
... View more
2 weeks ago
|
1
|
0
|
71
|
|
POST
|
Yeah I explored that as a possibility a few years ago and came to the conclusion that it's nearly impossible to afford Pro licenses a la carte and the only economical way to support 5+ ish users is to purchase an ELA (which we don't have but I suspect we will be purchasing given this information).
... View more
2 weeks ago
|
0
|
0
|
172
|
|
POST
|
I also read through the lines and it sounds like if an organization is still using a legacy concurrent license structure for their desktop applications, this change essentially kills that off. I got the "yeah pretty much" confirmation from my account manager (details to follow, of course). Does anyone use concurrent licensing and have any information about what this will do to their deployments? I'm having a meeting with my account reps next week and so I can return with details, but if anyone can give me additional context in advance I'd appreciate it.
... View more
2 weeks ago
|
0
|
2
|
175
|
|
POST
|
I just marked my comment on page 1 as the solution since that got it working for me. There are pictures to illustrate the parameters so hopefully that helps you. These are all database feature classes in Pro, so if you're doing it online in some fashion, that'd be a different environment and might cause different behavior.
... View more
2 weeks ago
|
0
|
3
|
62
|
|
POST
|
Ideally I'd avoid extra lines though I had thought of that option too - do you have an example of the nested If syntax? The Survey123 connect syntax turns me around sometimes.
... View more
2 weeks ago
|
0
|
2
|
77
|
|
IDEA
|
I have this issue as well with slightly different criteria: When I add a layer as a feature service <rest URl/FeatureServer/0> for example, then I can get all of the options, but when I add it as <rest URl/MapServer/0> then I get only list. I'm working with referenced data in Enterprise - this seems like it should just never be an issue. I want a edit-proofed service that can show attachments!
... View more
2 weeks ago
|
0
|
0
|
49
|
|
POST
|
Hello, I am trying to do some conditional calculating. I have an address field in my survey and I'm using pulldata @layer to get the address of a parcel that the point is placed on. If the point is not placed on a parcel, I'd like to return a piece of text like "No Address Found" or something. My actual pulldata is working fine, I get addresses when the point is on a parcel, but I want to set a default value. From what I understand, actually using Default might not work because that only evaluates when the survey is opened, so if I click a point that isn't on an address, then the default is overwritten with nothing. pulldata("@layer", "getValueAt", "attributes.ADDRESS", "<parcel REST endpoint>", ${EP311_point})
... View more
2 weeks ago
|
0
|
4
|
177
|
|
IDEA
|
@DavidWittmann Yes! I really wish I could have the minutes/hours back that I've spent reconfiguring filters when simply copying the SQL would be so easy.
... View more
2 weeks ago
|
0
|
0
|
166
|
|
IDEA
|
I don't know much of a better way to explain the issue other than that entering text and dynamic attributes in Experience Builder just feels unnecessarily difficult. As an example, I'm working on building an expression in the Set Link portion of a button widget. For starters, I can't even copy-paste text into this box, which is very irritating. Secondly, I forgot to enter the quotes around ?subject=RE%3A%20EP%20311%20Request. I clicked ahead of the ? and try to type in a quote, but it only enters both sets of quotes and if I try to delete one, it will delete both of them. There are other issues when working with text widgets as well, such as when using dynamic attributes. If I need to swap out a dynamic attribute in a text string it will often but not always completely remove the formatting. Things like this make Experience Builder feel really tedious, and for a program that is supposed to do a lot of heavy lifting for ESRIs web platform, it feels like it should just, work a little better.
... View more
2 weeks ago
|
11
|
4
|
255
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 08-02-2023 05:43 AM | |
| 1 | 09-28-2023 10:17 AM | |
| 1 | 09-27-2023 06:14 AM | |
| 1 | 09-25-2023 06:19 AM | |
| 1 | 2 weeks ago |
Activity Feed
- Kudoed Attachment Management Widget for Experience Builder for Kara_Shindle. 10 hours ago
- Got a Kudo for Re: How to change default docked popup location in Experience Builder. yesterday
- Got a Kudo for Re: Domain does not update when service is republished. yesterday
- Got a Kudo for Re: Domain does not update when service is republished. yesterday
- Posted Re: Public survey is requesting a sign in, portal 10.8.1 on ArcGIS Survey123 Questions. Wednesday
- Got a Kudo for Re: Web Apps Ungroup Legend Symbology. Tuesday
- Posted Re: Arcade Succeeds in Map Viewer but Fails in Field Maps on ArcGIS Enterprise Portal Questions. Monday
- Got a Kudo for ExB should recognize identical maps/schemas. Monday
- Posted Re: Preserving Global IDs with ArcPro 3.2 Append on ArcGIS Pro Questions. a week ago
- Posted Re: Arcade Succeeds in Map Viewer but Fails in Field Maps on ArcGIS Enterprise Portal Questions. a week ago
- Posted Arcade Succeeds in Map Viewer but Fails in Field Maps on ArcGIS Enterprise Portal Questions. a week ago
- Posted Re: Arcade help - labels on ArcGIS Pro Questions. a week ago
- Got a Kudo for Re: Lessons Learned — Attribute Rules. a week ago
- Got a Kudo for Re: Lessons Learned — Attribute Rules. a week ago
- Got a Kudo for Re: Lessons Learned — Attribute Rules. a week ago
- Got a Kudo for Make it easier to type in ExB. a week ago
- Got a Kudo for Make it easier to type in ExB. 2 weeks ago
- Got a Kudo for ExB should recognize identical maps/schemas. 2 weeks ago
- Got a Kudo for Re: Conditional Calculation with pulldata @layer. 2 weeks ago
- Posted Re: Conditional Calculation with pulldata @layer on ArcGIS Survey123 Questions. 2 weeks ago
Contact Me
| Online Status |
Online
|
| Date Last Visited |
14 hours ago
|