Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16521 | 16521 | 19806 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 100 STAIRWAY23 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60ST | ||||||||
| 17242 | 17242 | 4298 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 4350 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001589.80492 | 2100313.4171 | 37.7471502929454 | -122.437250699681 | (37.7471502929454, -122.437250699681) | |||
| 17261 | 17261 | 2372 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2527 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6009769.958330001 | 2102611.45041 | 37.753921802157706 | -122.40912639109699 | (37.7539218021577, -122.409126391097) | |||
| 17278 | 17278 | 2375 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2547 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009774.35605 | 2102523.0562 | 37.753679337750604 | -122.409104945855 | (37.7536793377506, -122.409104945855) | |||
| 17306 | 17306 | 2392 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2655 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009810.34614 | 2101884.53168 | 37.751928107698 | -122.408935435327 | (37.751928107698, -122.408935435327) | |||
| 17519 | 17519 | 2314 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2253 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009680.74998 | 2104241.2199 | 37.7583917852794 | -122.409549914219 | (37.7583917852794, -122.409549914219) | |||
| 17537 | 17537 | 2317 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2266 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6009618.58082 | 2104167.6101900004 | 37.758186185862606 | -122.409759727848 | (37.7581861858626, -122.409759727848) | |||
| 17542 | 17542 | 2343 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2385 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 3X3 | 6009722.48016 | 2103476.08894 | 37.7562932460395 | -122.40935159661501 | (37.7562932460395, -122.409351596615) | |||
| 17558 | 17558 | 2327 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2301 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5X5 | 6009698.3897 | 2103901.33897 | 37.757459537241395 | -122.409464921063 | (37.7574595372414, -122.409464921063) | |||
| 17562 | 17562 | 4250 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4047 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003586.97779 | 2100377.2494099997 | 37.747438891704505 | -122.43034919167201 | (37.7474388917045, -122.430349191672) | |||
| 17564 | 17564 | 4458 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1420 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1994 12:00:00 AM | 3 | 3X3 | 6004503.18681 | 2100562.9723099996 | 37.7480006990827 | -122.427194227854 | (37.7480006990827, -122.427194227854) | ||
| 17638 | 17638 | 2318 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2270 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 5X5 | 6009620.42845 | 2104139.7744 | 37.7581098586044 | -122.40975137312999 | (37.7581098586044, -122.40975137313) | |||
| 18117 | 18117 | 11765 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800X Junipero Serra Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991272.34511 | 2091581.45548 | 37.7225826231682 | -122.47229087392 | (37.7225826231682, -122.47229087392) | ||
| 18250 | 18250 | 2427 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2884 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6009813.095380001 | 2100671.03054 | 37.7485962562324 | -122.408840321235 | (37.7485962562324, -122.408840321235) | |||
| 18300 | 18300 | 2394 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2661 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 7X6 | 6009814.716440001 | 2101845.61428 | 37.7518214939686 | -122.408917576591 | (37.7518214939686, -122.408917576591) | |||
| 18504 | 18504 | 2406 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2729 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6009835.509980001 | 2101434.53387 | 37.7506939230859 | -122.408816669975 | (37.7506939230859, -122.408816669975) | |||
| 18551 | 18551 | 2379 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2565 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6009779.24964 | 2102431.71295 | 37.753428803702 | -122.40908157785101 | (37.753428803702, -122.409081577851) | |||
| 18776 | 18776 | 2310 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2227 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009672.2386 | 2104377.81978 | 37.758766380788 | -122.409588991562 | (37.758766380788, -122.409588991562) | |||
| 18793 | 18793 | 114373 | Property Tree 7 | Liquidambar styraciflua :: American Sweet Gum 62 | 805 GONZALEZ DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 5988302.0 | 2089566.0 | 37.7168763353695 | -122.482410970247 | (37.7168763353695, -122.482410970247) | ||||
| 18937 | 18937 | 2410 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2753 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/04/2003 12:00:00 AM | 3 | 3x3 | 6009844.62689 | 2101286.4895200003 | 37.7502879367387 | -122.40877469949 | (37.7502879367387, -122.40877469949) | ||
| 19144 | 19144 | 2409 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2743 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1996 12:00:00 AM | 8 | 3X3 | 6009838.5674 | 2101356.55662 | 37.7504799860819 | -122.40880059638901 | (37.7504799860819, -122.408800596389) | ||
| 19206 | 19206 | 2364 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2483 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009753.556480001 | 2102901.70574 | 37.754717859559996 | -122.40920359338499 | (37.75471785956, -122.409203593385) | |||
| 19304 | 19304 | 2308 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2205 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/16/1990 12:00:00 AM | 26 | 5x5 | 6009667.68521 | 2104459.2052 | 37.7589895916184 | -122.40961048355 | (37.7589895916184, -122.40961048355) | ||
| 19343 | 19343 | 28266 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 702 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/04/2002 12:00:00 AM | 12 | 3x3 | 6002735.2568 | 2109243.2194 | 37.7717344296193 | -122.43392801598301 | (37.7717344296193, -122.433928015983) | ||
| 19477 | 19477 | 2420 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2825 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/1996 12:00:00 AM | 12 | 3X3 | 6009867.3992099995 | 2100896.25477 | 37.74921771384761 | -122.40866842482201 | (37.7492177138476, -122.408668424822) | ||
| 19596 | 19596 | 2329 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2309 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6009696.95759 | 2103872.6762900003 | 37.7573807557313 | -122.409467851061 | (37.7573807557313, -122.409467851061) | |||
| 19813 | 19813 | 29581 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500X Junipero Serra Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991390.5187800005 | 2093368.54568 | 37.7274963677541 | -122.47201256884199 | (37.7274963677541, -122.472012568842) | ||
| 19955 | 19955 | 29580 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 500X Junipero Serra Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991386.6913 | 2093344.7747799999 | 37.7274308773069 | -122.47202406848 | (37.7274308773069, -122.47202406848) | ||
| 20128 | 20128 | 11766 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800X Junipero Serra Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991273.54078 | 2091606.60865 | 37.72265175674929 | -122.47228857348101 | (37.7226517567493, -122.472288573481) | ||
| 20167 | 20167 | 2332 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2318 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6X6 | 6009643.236190001 | 2103731.69198 | 37.7569906343237 | -122.409643691024 | (37.7569906343237, -122.409643691024) | |||
| 20430 | 20430 | 2398 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2700 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6009763.2742 | 2101575.57486 | 37.7510771440053 | -122.409076419352 | (37.7510771440053, -122.409076419352) | |||
| 20543 | 20543 | 2353 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2413 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/03/2013 12:00:00 AM | 3 | 4X4 | 6009731.35926 | 2103287.7886799998 | 37.7557767132463 | -122.409307601761 | (37.7557767132463, -122.409307601761) | ||
| 20689 | 20689 | 2421 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2834 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6009805.25518 | 2100829.83171 | 37.7490318500391 | -122.408878635061 | (37.7490318500391, -122.408878635061) | |||
| 20799 | 20799 | 2336 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2350 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6009647.84885 | 2103642.0545799998 | 37.7567447686625 | -122.40962141212201 | (37.7567447686625, -122.409621412122) | |||
| 20957 | 20957 | 4302 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 4378 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001457.95867 | 2100305.5079 | 37.747121080269295 | -122.437706046203 | (37.7471210802693, -122.437706046203) | |||
| 21051 | 21051 | 2331 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2311 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6009700.99321 | 2103848.9649799997 | 37.7573158759309 | -122.409452220849 | (37.7573158759309, -122.409452220849) | |||
| 21060 | 21060 | 2380 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2566 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6009717.08187 | 2102390.53262 | 37.7533122488659 | -122.409293662278 | (37.7533122488659, -122.409293662278) | |||
| 21122 | 21122 | 2423 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2840 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6009807.43229 | 2100804.44049 | 37.748962253304 | -122.408869315378 | (37.748962253304, -122.408869315378) | |||
| 21126 | 21126 | 2414 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2786 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009786.496590001 | 2101143.3199400003 | 37.749891568653496 | -122.408965618395 | (37.7498915686535, -122.408965618395) | |||
| 21137 | 21137 | 2330 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2312 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6009640.84961 | 2103785.73358 | 37.7571388866594 | -122.409655759023 | (37.7571388866594, -122.409655759023) | |||
| 21155 | 21155 | 2419 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2822 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009803.315230001 | 2100866.84766 | 37.7491333789981 | -122.408887954717 | (37.7491333789981, -122.408887954717) | |||
| 21192 | 21192 | 3896 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 60 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5X5 | 6002168.7084800005 | 2107927.71258 | 37.7680902055206 | -122.435793601904 | (37.7680902055206, -122.435793601904) | |||
| 21374 | 21374 | 2362 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2473 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009749.23862 | 2102948.41566 | 37.7548458726476 | -122.40922182173 | (37.7548458726476, -122.40922182173) | |||
| 21487 | 21487 | 2309 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 2213 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009668.22468 | 2104416.43849 | 37.7588721941234 | -122.409605599315 | (37.7588721941234, -122.409605599315) | |||
| 21559 | 21559 | 19144 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 45 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6003508.29583 | 2108036.92775 | 37.768466086156394 | -122.431167909289 | (37.7684660861564, -122.431167909289) | |||
| 21566 | 21566 | 2377 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2553 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6009776.86013 | 2102474.30381 | 37.7535456148439 | -122.409092846361 | (37.7535456148439, -122.409092846361) | |||
| 21572 | 21572 | 2411 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2759 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1999 12:00:00 AM | 6 | 4X4 | 6009845.01424 | 2101254.8528 | 37.7502010910033 | -122.408771128311 | (37.7502010910033, -122.408771128311) | ||
| 21741 | 21741 | 2404 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2724 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6009770.26673 | 2101463.3127900003 | 37.750769288979605 | -122.409044318046 | (37.7507692889796, -122.409044318046) | |||
| 21942 | 21942 | 11767 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800X Junipero Serra Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991276.05264 | 2091631.0711599998 | 37.7227190701221 | -122.472281672976 | (37.7227190701221, -122.472281672976) | ||
| 22378 | 22378 | 26756 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005569.26951 | 2114444.1495 | 37.7861753317646 | -122.424494982868 | (37.7861753317646, -122.424494982868) | |||
| 22416 | 22416 | 26753 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005527.1532 | 2114438.07435 | 37.7861562724304 | -122.424640262031 | (37.7861562724304, -122.424640262031) | |||
| 22571 | 22571 | 26752 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005515.49515 | 2114435.63395 | 37.7861489132884 | -122.424680422175 | (37.7861489132884, -122.424680422175) | |||
| 22634 | 22634 | 26754 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005539.86656 | 2114440.61457 | 37.7861639652384 | -122.424596457885 | (37.7861639652384, -122.424596457885) | |||
| 22794 | 22794 | 26757 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005593.49204 | 2114448.7926 | 37.786189448429205 | -122.42441150958099 | (37.7861894484292, -122.424411509581) | |||
| 22804 | 22804 | 26755 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1399 Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005555.38127 | 2114442.5721400003 | 37.7861702164197 | -122.424542920326 | (37.7861702164197, -122.424542920326) | |||
| 23828 | 23828 | 177148 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100 Junipero Serra Blvd | 11 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991345.1062 | 2088786.2704900003 | 37.7149119421181 | -122.47183574413401 | (37.7149119421181, -122.471835744134) | |||
| 23897 | 23897 | 248466 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 144 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998292.5435 | 2107918.5956 | 37.7678442300261 | -122.449200130602 | (37.7678442300261, -122.449200130602) | |||
| 24243 | 24243 | 191114 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201 22nd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6014324.849769999 | 2103848.63349 | 37.7575729597541 | -122.393460960954 | (37.7575729597541, -122.393460960954) | |||
| 24503 | 24503 | 191147 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 44 Boardman Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011750.26705 | 2110044.73207 | 37.7744426675252 | -122.40280071719201 | (37.7744426675252, -122.402800717192) | |||
| 24508 | 24508 | 138147 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1855 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000229.7014 | 2111271.7391 | 37.777161724967996 | -122.442740548891 | (37.777161724968, -122.442740548891) | |||
| 24517 | 24517 | 129740 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 John Maher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6012353.73266 | 2119674.7684299997 | 37.8009181627066 | -122.401390109871 | (37.8009181627066, -122.401390109871) | |||
| 24703 | 24703 | 208140 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 9 Keystone Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994042.19484 | 2092647.64079 | 37.7256700254358 | -122.462793502527 | (37.7256700254358, -122.462793502527) | |||
| 24770 | 24770 | 227722 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 845 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5999121.83175 | 2107384.4786900003 | 37.7664250774754 | -122.44629330369601 | (37.7664250774754, -122.446293303696) | |||
| 24970 | 24970 | 227868 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 390 Sanchez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003558.10771 | 2106024.70188 | 37.7629438234204 | -122.430851992743 | (37.7629438234204, -122.430851992743) | |||
| 25223 | 25223 | 208086 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800x Junipero Serra Blvd | 56 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5991357.47228 | 2092905.4597099999 | 37.7262229367261 | -122.472093069866 | (37.7262229367261, -122.472093069866) | |||
| 25393 | 25393 | 228021 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1054 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5998157.054409999 | 2106607.36365 | 37.7642361689933 | -122.44957427424102 | (37.7642361689933, -122.449574274241) | |||
| 25442 | 25442 | 227871 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3800 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004234.236219999 | 2104844.24859 | 37.7597408654757 | -122.428429354932 | (37.7597408654757, -122.428429354932) | |||
| 25463 | 25463 | 200261 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 243 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009424.87449 | 2110575.33974 | 37.7757694778185 | -122.410882207661 | (37.7757694778185, -122.410882207661) | |||
| 25465 | 25465 | 208048 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2344 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5992344.38135 | 2099463.27392 | 37.74428611053071 | -122.469158483081 | (37.7442861105307, -122.469158483081) | |||
| 25607 | 25607 | 227742 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1232 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5997482.84112 | 2105527.7140599997 | 37.761233131234896 | -122.451828281975 | (37.7612331312349, -122.451828281975) | |||
| 25626 | 25626 | 129738 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 6 John Maher St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012361.066869999 | 2119691.7640299997 | 37.800965237719204 | -122.40136592529801 | (37.8009652377192, -122.401365925298) | |||
| 25648 | 25648 | 191123 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 601 Carolina St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 6012425.58055 | 2105029.27463 | 37.7607090306229 | -122.400112358502 | (37.7607090306229, -122.400112358502) | |||
| 25894 | 25894 | 227929 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3110 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002869.05371 | 2095746.24255 | 37.7346825264594 | -122.432500998617 | (37.7346825264594, -122.432500998617) | |||
| 26117 | 26117 | 129704 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3000 Washington St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 3ft | 6000269.523080001 | 2116153.9558 | 37.7905693023891 | -122.442953484235 | (37.7905693023891, -122.442953484235) | |||
| 26172 | 26172 | 246467 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 244 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6004891.34106 | 2099910.0636400003 | 37.7462299051934 | -122.42580553881099 | (37.7462299051934, -122.425805538811) | |||
| 26311 | 26311 | 227767 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 4475 24th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 6000143.14107 | 2101645.6357400003 | 37.7507259002966 | -122.442348757612 | (37.7507259002966, -122.442348757612) | |||
| 26456 | 26456 | 246068 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 5 Central Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999954.0153 | 2108402.9707 | 37.7692690935594 | -122.443488110434 | (37.7692690935594, -122.443488110434) | |||
| 26594 | 26594 | 208099 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2291 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991681.99819 | 2099835.94672 | 37.745271077706704 | -122.471475991035 | (37.7452710777067, -122.471475991035) | |||
| 26610 | 26610 | 228013 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1343 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5998231.8221 | 2105759.10992 | 37.76191135493279 | -122.449254558076 | (37.7619113549328, -122.449254558076) | |||
| 26638 | 26638 | 200276 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Lane St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017047.12766 | 2097054.90505 | 37.7390696568319 | -122.383573170476 | (37.7390696568319, -122.383573170476) | |||
| 26653 | 26653 | 208094 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1284 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5993960.310959999 | 2106767.61522 | 37.7644351970401 | -122.46410113478001 | (37.7644351970401, -122.46410113478) | |||
| 26865 | 26865 | 200267 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 860x Jamestown Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 6014763.4294300005 | 2089103.4873400002 | 37.7171101711671 | -122.39091365107001 | (37.7171101711671, -122.39091365107) | |||
| 26876 | 26876 | 129739 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 6 John Maher St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6012352.16177 | 2119689.7384 | 37.8009591789808 | -122.401396598486 | (37.8009591789808, -122.401396598486) | |||
| 27352 | 27352 | 227958 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3627 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6005410.5124699995 | 2104865.85603 | 37.7598666869207 | -122.42436272946199 | (37.7598666869207, -122.424362729462) | |||
| 27545 | 27545 | 140410 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1325 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003227.817000001 | 2112933.649 | 37.7818953731726 | -122.43248785744301 | (37.7818953731726, -122.432487857443) | |||
| 27561 | 27561 | 227876 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 133 Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002056.6842 | 2105072.72951 | 37.7602447556215 | -122.43597676861 | (37.7602447556215, -122.43597676861) | |||
| 27635 | 27635 | 129744 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 John Maher St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6012609.98453 | 2119710.6419 | 37.801030956563395 | -122.400505885653 | (37.8010309565634, -122.400505885653) | |||
| 27768 | 27768 | 208072 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 48 Marcela Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5994750.66862 | 2100768.2505900003 | 37.7480079970652 | -122.460932676625 | (37.7480079970652, -122.460932676625) | |||
| 27892 | 27892 | 208144 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 40 Garcia Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 5995206.64176 | 2099494.55804 | 37.7445369826924 | -122.459263729149 | (37.7445369826924, -122.459263729149) | |||
| 27923 | 27923 | 208116 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 239 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5994839.35424 | 2100452.13911 | 37.747145137147704 | -122.460603103876 | (37.7471451371477, -122.460603103876) | |||
| 27930 | 27930 | 129716 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6006809.35 | 2120459.5660099997 | 37.8027621146536 | -122.42063180021299 | (37.8027621146536, -122.420631800213) | |||
| 28050 | 28050 | 129731 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 332 Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6011929.52293 | 2119129.4911700003 | 37.7993972859062 | -122.402819692899 | (37.7993972859062, -122.402819692899) | |||
| 28107 | 28107 | 129718 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006845.74669 | 2120464.39586 | 37.8027774273877 | -122.42050619192699 | (37.8027774273877, -122.420506191927) | |||
| 28121 | 28121 | 139774 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400 FILLMORE ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003214.319 | 2113328.8398 | 37.782979702448394 | -122.43256279089898 | (37.7829797024484, -122.432562790899) | |||
| 28215 | 28215 | 247280 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 520 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998954.6357 | 2108912.2879 | 37.7706105046931 | -122.446981556392 | (37.7706105046931, -122.446981556392) | |||
| 28393 | 28393 | 129742 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 John Maher St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6012372.32254 | 2119675.23965 | 37.8009204937473 | -122.401325813756 | (37.8009204937473, -122.401325813756) | |||
| 28612 | 28612 | 129695 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6000588.35894 | 2116200.69282 | 37.7907158028324 | -122.441853689821 | (37.7907158028324, -122.441853689821) | |||
| 28751 | 28751 | 72246 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 418 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 6 | 6002360.66039 | 2091027.7988900002 | 37.721697906115104 | -122.433921526363 | (37.7216979061151, -122.433921526363) | ||
| 28803 | 28803 | 227813 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 168 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5999428.13676 | 2107230.4029200003 | 37.7660195129085 | -122.445222775925 | (37.7660195129085, -122.445222775925) | |||
| 28836 | 28836 | 200258 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 46 Boardman Pl | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011826.839269999 | 2109963.92529 | 37.7742250657728 | -122.40253015436501 | (37.7742250657728, -122.402530154365) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");