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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 133071 | 133071 | 203620 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 358 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994207.97815 | 2101247.70705 | 37.7492932209146 | -122.46284404261101 | (37.7492932209146, -122.462844042611) | |||
| 179698 | 179698 | 218406 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 225 Castenada Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5994236.919980001 | 2100511.7669599997 | 37.7472741826649 | -122.462690582315 | (37.7472741826649, -122.462690582315) | |||
| 64167 | 64167 | 203628 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 133 Maywood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5994258.53071 | 2095683.80268 | 37.734019041749 | -122.46226575516701 | (37.734019041749, -122.462265755167) | |||
| 51056 | 51056 | 203627 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 133 Maywood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5994260.237269999 | 2095673.9858 | 37.7339921852793 | -122.462259143365 | (37.7339921852793, -122.462259143365) | |||
| 42992 | 42992 | 32891 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1515 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37234 | 5994269.30013039 | 2105266.22888454 | 37.760330583946796 | -122.462923499947 | (37.7603305839468, -122.462923499947) | ||
| 128285 | 128285 | 32890 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1515 06th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37234 | 5994269.30013039 | 2105266.22888454 | 37.760330583946796 | -122.462923499947 | (37.7603305839468, -122.462923499947) | ||
| 101308 | 101308 | 43731 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 766 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43368 | 5994373.49554275 | 2089956.67715953 | 37.7183003625969 | -122.461453233071 | (37.7183003625969, -122.461453233071) | ||
| 38639 | 38639 | 174959 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 103 De Long St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 10ft | 5994397.11424 | 2086788.06602 | 37.709601466104104 | -122.461142043293 | (37.7096014661041, -122.461142043293) | |||
| 156503 | 156503 | 174960 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 103 De Long St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 10ft | 5994409.5991400005 | 2086788.1181299998 | 37.709602327657706 | -122.461098897396 | (37.7096023276577, -122.461098897396) | |||
| 135030 | 135030 | 75408 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994441.08765 | 2086786.6315099997 | 37.7096000577555 | -122.460989960739 | (37.7096000577555, -122.460989960739) | ||
| 174458 | 174458 | 203224 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 30 Northgate Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5994449.32754 | 2093942.03458 | 37.7292475573046 | -122.461479885289 | (37.7292475573046, -122.461479885289) | |||
| 176496 | 176496 | 75331 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 De Long St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994458.53323 | 2086786.7483599999 | 37.709601382461294 | -122.460929674682 | (37.7096013824613, -122.460929674682) | ||
| 27343 | 27343 | 203223 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 25 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994463.96401 | 2093754.2883099997 | 37.7287328942013 | -122.461415680898 | (37.7287328942013, -122.461415680898) | |||
| 149098 | 149098 | 75250 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 De Long St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994476.95751 | 2086787.3271700002 | 37.7096040318843 | -122.460866039547 | (37.7096040318843, -122.460866039547) | ||
| 77653 | 77653 | 109672 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 798x GRAFTON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994496.0 | 2090624.0 | 37.72013972186421 | -122.461078132621 | (37.7201397218642, -122.461078132621) | ||||
| 97305 | 97305 | 109671 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 798x GRAFTON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994496.0 | 2090624.0 | 37.72013972186421 | -122.461078132621 | (37.7201397218642, -122.461078132621) | ||||
| 173115 | 173115 | 203638 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 750 Grafton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994537.11563 | 2090599.0913099998 | 37.720073694513104 | -122.46093420637101 | (37.7200736945131, -122.460934206371) | |||
| 109135 | 109135 | 67746 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1479 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1992 12:00:00 AM | Permit Number 31365 | 5994572.72013397 | 2105470.39847949 | 37.7609086531136 | -122.461888924556 | (37.7609086531136, -122.461888924556) | ||
| 81990 | 81990 | 43708 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 503 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43349 | 5995017.92037976 | 2088722.8136211003 | 37.7149495354327 | -122.459136447344 | (37.7149495354327, -122.459136447344) | ||
| 103294 | 103294 | 43707 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 503 Capitol Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43349 | 5995017.92037976 | 2088722.8136211003 | 37.7149495354327 | -122.459136447344 | (37.7149495354327, -122.459136447344) | ||
| 144602 | 144602 | 43706 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 503 Capitol Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43349 | 5995017.92037976 | 2088722.8136211003 | 37.7149495354327 | -122.459136447344 | (37.7149495354327, -122.459136447344) | ||
| 101869 | 101869 | 66237 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 422 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29335 | 5995558.06563814 | 2090587.62307484 | 37.72010089980329 | -122.45740432201 | (37.7201008998033, -122.45740432201) | ||
| 79951 | 79951 | 32740 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 139 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37123 | 5995564.95354615 | 2088674.66529796 | 37.7148487646576 | -122.457242200681 | (37.7148487646576, -122.457242200681) | ||
| 96226 | 96226 | 32739 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 137 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37122 | 5995581.47746257 | 2088674.4560737 | 37.7148491391882 | -122.45718507236099 | (37.7148491391882, -122.457185072361) | ||
| 84092 | 84092 | 30931 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 407 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34744 | 5995614.80249177 | 2091194.83311768 | 37.7217714131354 | -122.457252106382 | (37.7217714131354, -122.457252106382) | ||
| 1362 | 1362 | 36186 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 133 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | 8 | Permit Number 39255 | 5995881.41756 | 2113499.8369 | 37.783030646722004 | -122.45794382331002 | (37.783030646722, -122.45794382331) | |
| 118826 | 118826 | 33189 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 76 Hernandez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37397 | 5996015.45875929 | 2099706.92373099 | 37.7451665539633 | -122.456482373988 | (37.7451665539633, -122.456482373988) | ||
| 123758 | 123758 | 33190 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 76 Hernandez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37397 | 5996015.45875929 | 2099706.92373099 | 37.7451665539633 | -122.456482373988 | (37.7451665539633, -122.456482373988) | ||
| 103621 | 103621 | 33192 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 53 Idora Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37399 | 5996322.19797653 | 2099597.08028102 | 37.7448825563847 | -122.455413791656 | (37.7448825563847, -122.455413791656) | ||
| 85817 | 85817 | 45250 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 200 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44097 | 5996410.188004401 | 2098465.43898756 | 37.7417803963921 | -122.45502778464599 | (37.7417803963921, -122.455027784646) | ||
| 87509 | 87509 | 66256 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 198 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29359 | 5996422.28373213 | 2098491.67117902 | 37.7418531174549 | -122.454987856884 | (37.7418531174549, -122.454987856884) | ||
| 61126 | 61126 | 50520 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 85 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 5 | Permit Number 47158 | 5996681.6204 | 2112482.6347 | 37.7802836203489 | -122.455101936973 | (37.7802836203489, -122.455101936973) | |
| 74240 | 74240 | 141691 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5996753.535 | 2112367.4021 | 37.7799713474759 | -122.45484482437 | (37.7799713474759, -122.45484482437) | |||
| 86247 | 86247 | 50653 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 151 Lawrence Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2003 12:00:00 AM | Permit Number 47235 | 5996872.39579561 | 2087134.54464453 | 37.710694953358995 | -122.452612074363 | (37.710694953359, -122.452612074363) | |||
| 80747 | 80747 | 68174 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 449 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/01/1995 12:00:00 AM | Permit Number 31945 | 5997091.52876923 | 2111801.84543591 | 37.778437859612005 | -122.45363471008001 | (37.778437859612, -122.45363471008) | ||
| 49864 | 49864 | 203621 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 21 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5997303.382119999 | 2099336.74248 | 37.7442239835511 | -122.452002277389 | (37.7442239835511, -122.452002277389) | |||
| 59298 | 59298 | 203625 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 15 Teresita Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5997311.4729 | 2099621.76413 | 37.7450070466421 | -122.45199486067499 | (37.7450070466421, -122.451994860675) | |||
| 43667 | 43667 | 203624 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 15 Teresita Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5997319.6106 | 2099609.0427 | 37.7449725828299 | -122.45196580449199 | (37.7449725828299, -122.451965804492) | |||
| 68717 | 68717 | 203626 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 12 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5997325.36011 | 2099393.7124400004 | 37.7443816679834 | -122.451930391889 | (37.7443816679834, -122.451930391889) | |||
| 93809 | 93809 | 203623 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 15 Teresita Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5997330.81089 | 2099592.0734900003 | 37.744926631064 | -122.45192585212 | (37.744926631064, -122.45192585212) | |||
| 112951 | 112951 | 65654 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 12 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 51556 | 5997336.22410326 | 2099411.42392563 | 37.744430921643 | -122.451894104171 | (37.744430921643, -122.451894104171) | ||
| 151042 | 151042 | 203622 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 15 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5997339.998380001 | 2099579.33016 | 37.7448921672303 | -122.45189316446002 | (37.7448921672303, -122.45189316446) | |||
| 126511 | 126511 | 49185 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 220 Palo Alto Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46291 | 5997532.34805472 | 2103898.27952644 | 37.7567619489163 | -122.451539524782 | (37.7567619489163, -122.451539524782) | |||
| 42561 | 42561 | 203661 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 582 Mangels Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5997537.55728 | 2095290.5878599999 | 37.7331276310309 | -122.450900858796 | (37.7331276310309, -122.450900858796) | |||
| 76199 | 76199 | 220046 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 170 Saint Germain Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5997546.7288 | 2104141.22433 | 37.7574298380281 | -122.451507313917 | (37.7574298380281, -122.451507313917) | |||
| 64130 | 64130 | 248395 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1655 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997659.0251 | 2108142.2349 | 37.768422030688896 | -122.451407517669 | (37.7684220306889, -122.451407517669) | |||
| 154005 | 154005 | 248396 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1655 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997671.1383 | 2108143.749 | 37.768426881635605 | -122.45136572862499 | (37.7684268816356, -122.451365728625) | |||
| 101299 | 101299 | 39622 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41021 | 5997705.33041065 | 2106460.2771729 | 37.7638064542355 | -122.451126043319 | (37.7638064542355, -122.451126043319) | ||
| 109830 | 109830 | 39623 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41021 | 5997705.33041065 | 2106460.2771729 | 37.7638064542355 | -122.451126043319 | (37.7638064542355, -122.451126043319) | ||
| 58064 | 58064 | 220047 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1201 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5997716.00381 | 2106428.96316 | 37.7637210849721 | -122.451086869165 | (37.7637210849721, -122.451086869165) | |||
| 35427 | 35427 | 203633 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 458 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5997727.849830001 | 2094119.15999 | 37.7299220605503 | -122.45015856377199 | (37.7299220605503, -122.450158563772) | |||
| 82740 | 82740 | 67907 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 557 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/08/1994 12:00:00 AM | Permit Number 31610 | 5997734.62104287 | 2094370.88558597 | 37.7306136268107 | -122.450153291964 | (37.7306136268107, -122.450153291964) | ||
| 93386 | 93386 | 41149 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1653 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1999 12:00:00 AM | Permit Number 41881 | 5997742.91613306 | 2108148.62427098 | 37.7684443776569 | -122.45111780839 | (37.7684443776569, -122.45111780839) | |||
| 113622 | 113622 | 41148 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1653 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | Permit Number 41881 | 5997742.91613306 | 2108148.62427098 | 37.7684443776569 | -122.45111780839 | (37.7684443776569, -122.45111780839) | ||
| 69034 | 69034 | 220048 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1401 Rivoli St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 5997746.6978 | 2105897.5577 | 37.7622637372081 | -122.450942387687 | (37.7622637372081, -122.450942387687) | |||
| 167945 | 167945 | 220049 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1401 Rivoli St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 5997764.73117 | 2105899.6107 | 37.7622704065882 | -122.450880165397 | (37.7622704065882, -122.450880165397) | |||
| 3060 | 3060 | 203634 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 432 Flood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | 11 | Width 2ft | Permit Number 42544 | 5997859.0322900005 | 2094116.10367 | 37.7299211747225 | -122.449704832412 | (37.7299211747225, -122.449704832412) | |
| 108121 | 108121 | 42339 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 432 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42544 | 5997882.68725291 | 2094126.21532195 | 37.7299502922476 | -122.449623783134 | (37.7299502922476, -122.449623783134) | ||
| 99304 | 99304 | 44327 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1586 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/2001 12:00:00 AM | 8 | 2x3 | Permit Number 43713 | 5997934.27114243 | 2105194.99069947 | 37.7603454014574 | -122.45024300053001 | (37.7603454014574, -122.45024300053) | |
| 54361 | 54361 | 203635 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 418 Flood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5997950.41926 | 2094116.13567 | 37.7299264906077 | -122.44938890058201 | (37.7299264906077, -122.449388900582) | |||
| 183501 | 183501 | 203636 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 418 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5997970.50252 | 2094115.71728 | 37.7299264906074 | -122.449319440552 | (37.7299264906074, -122.449319440552) | |||
| 123798 | 123798 | 67185 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 154 Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | 12 | Permit Number 30632 | 5998076.31886872 | 2105384.33640813 | 37.76087342528071 | -122.44976537124599 | (37.7608734252807, -122.449765371246) | |
| 96633 | 96633 | 42373 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 531 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42548 | 5998094.3919548 | 2095072.92519048 | 37.7325618425703 | -122.448960067148 | (37.7325618425703, -122.448960067148) | ||
| 116996 | 116996 | 42372 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 531 Foerster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42548 | 5998094.3919548 | 2095072.92519048 | 37.7325618425703 | -122.448960067148 | (37.7325618425703, -122.448960067148) | ||
| 132310 | 132310 | 203658 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 531 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998103.1876300005 | 2095162.16833 | 37.732807386054795 | -122.448936084745 | (37.7328073860548, -122.448936084745) | |||
| 50765 | 50765 | 244169 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1752 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998187.9203 | 2108956.9743 | 37.7706893684237 | -122.449636842472 | (37.7706893684237, -122.449636842472) | |||
| 103431 | 103431 | 32273 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | Permit Number 36859 | 5998193.43438826 | 2108958.37890696 | 37.7706935405733 | -122.449617870473 | (37.7706935405733, -122.449617870473) | |||
| 61594 | 61594 | 203663 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 271 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5998288.8054599995 | 2093783.09686 | 37.7290313953773 | -122.44819509282699 | (37.7290313953773, -122.448195092827) | |||
| 148365 | 148365 | 203637 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 270 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5998290.1238 | 2093810.02027 | 37.7291053960882 | -122.448192473116 | (37.7291053960882, -122.448192473116) | |||
| 33978 | 33978 | 203629 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 138 Encline Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5998295.84832 | 2098462.32087 | 37.7418798313816 | -122.448507597342 | (37.7418798313816, -122.448507597342) | |||
| 53663 | 53663 | 220045 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 160 Marview Way | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5998323.68704 | 2103258.27383 | 37.755049936933 | -122.448756699664 | (37.755049936933, -122.448756699664) | |||
| 157007 | 157007 | 220696 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 407 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998482.20862 | 2106820.01065 | 37.764838640103505 | -122.44846497847799 | (37.7648386401035, -122.448464978478) | |||
| 41964 | 41964 | 246075 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 635 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998492.5621 | 2108432.0423 | 37.7692654626532 | -122.44854527514299 | (37.7692654626532, -122.448545275143) | |||
| 62430 | 62430 | 246034 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 618 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998524.9649 | 2108501.9958 | 37.7694593898353 | -122.44843823441002 | (37.7694593898353, -122.44843823441) | |||
| 127159 | 127159 | 39701 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 625 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41086 | 5998544.21434681 | 2094768.39031032 | 37.7317513769747 | -122.447383017512 | (37.7317513769747, -122.447383017512) | ||
| 179419 | 179419 | 203660 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 634 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5998582.52704 | 2094910.5588200002 | 37.732143927389295 | -122.44726079165399 | (37.7321439273893, -122.447260791654) | |||
| 166210 | 166210 | 203659 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 628 Edna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5998583.28764 | 2094893.18321 | 37.7320962615306 | -122.44725691200199 | (37.7320962615306, -122.447256912002) | |||
| 88651 | 88651 | 51518 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 622 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2005 12:00:00 AM | Permit Number 47821 | 5998596.12110377 | 2094762.07724114 | 37.731737008800394 | -122.44720311183701 | (37.7317370088004, -122.447203111837) | |||
| 108082 | 108082 | 39702 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 628 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/2004 12:00:00 AM | Permit Number 41087 | 5998596.38137062 | 2094778.55233682 | 37.731782260395 | -122.447203397318 | (37.731782260395, -122.447203397318) | ||
| 18568 | 18568 | 39703 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 634 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41088 | 5998596.64163755 | 2094795.02743762 | 37.7318275120035 | -122.44720368280001 | (37.7318275120035, -122.4472036828) | ||
| 51120 | 51120 | 66858 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 103 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/1991 12:00:00 AM | 9 | Permit Number 30164 | 5998644.5770000005 | 2110362.2819 | 37.774574098301294 | -122.448158471707 | (37.7745740983013, -122.448158471707) | ||
| 161597 | 161597 | 220697 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 897 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5998695.14565 | 2106960.91022 | 37.7652376872994 | -122.447738631145 | (37.7652376872994, -122.447738631145) | |||
| 181115 | 181115 | 203656 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 232 Edna St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 5998785.56076 | 2095387.29688 | 37.733464536852395 | -122.446593149381 | (37.7334645368524, -122.446593149381) | ||||
| 53649 | 53649 | 219989 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 936 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998793.85425 | 2106724.38466 | 37.7645938887298 | -122.447380197361 | (37.7645938887298, -122.447380197361) | |||
| 170961 | 170961 | 219988 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 936 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998797.49873 | 2106712.69483 | 37.7645619996538 | -122.447366750686 | (37.7645619996538, -122.447366750686) | |||
| 180380 | 180380 | 203655 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 230 Edna St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998797.91036 | 2095380.6148 | 37.7334468948521 | -122.446549972903 | (37.7334468948521, -122.446549972903) | ||||
| 75943 | 75943 | 44033 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 230 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/02/2000 12:00:00 AM | 9 | Permit Number 43569 | 5998819.8857 | 2109894.1205 | 37.7732986671632 | -122.447518341015 | (37.7732986671632, -122.447518341015) | |
| 24164 | 24164 | 54840 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 236 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1983 12:00:00 AM | 6 | 3x3 | Permit Number 10695 | 5998822.5685 | 2109866.5256 | 37.77322305193879 | -122.447507074191 | (37.7732230519388, -122.447507074191) |
| 140403 | 140403 | 1378 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 65 Amethyst Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/1998 12:00:00 AM | 7 | 1X1 | 5998886.878159099 | 2099985.9166978 | 37.746097033504896 | -122.44657360851801 | (37.7460970335049, -122.446573608518) | ||
| 21718 | 21718 | 22808 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 19 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/1991 12:00:00 AM | 3 | 2X2 | 5998906.136630001 | 2099819.83871 | 37.745642123584105 | -122.446495069307 | (37.7456421235841, -122.446495069307) | ||
| 112276 | 112276 | 50450 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1418 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47096 | 5998923.01373461 | 2108365.57348999 | 37.7691075589972 | -122.44705158673901 | (37.7691075589972, -122.447051586739) | |||
| 145663 | 145663 | 50449 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1418 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47096 | 5998923.01373461 | 2108365.57348999 | 37.7691075589972 | -122.44705158673901 | (37.7691075589972, -122.447051586739) | |||
| 20126 | 20126 | 22809 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 19 Turquoise Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1998 12:00:00 AM | 3 | 3x3 | 5998930.058209999 | 2099793.7189700003 | 37.745571771416294 | -122.446410473673 | (37.7455717714163, -122.446410473673) | ||
| 18171 | 18171 | 1377 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 65 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/1998 12:00:00 AM | 3 | 1X1 | 5998937.99517 | 2100006.33795 | 37.746156024995706 | -122.44639832203 | (37.7461560249957, -122.44639832203) | ||
| 47237 | 47237 | 220016 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 70 Quartz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998965.77386 | 2099787.09557 | 37.74555562500829 | -122.44628649854201 | (37.7455556250083, -122.446286498542) | |||
| 155339 | 155339 | 31136 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 371 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 6 | Permit Number 34851 | 5998968.1475599995 | 2094360.3261099998 | 37.730655144717105 | -122.445888061981 | (37.7306551447171, -122.445888061981) | |
| 92174 | 92174 | 50672 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3305 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47252 | 5998970.56266258 | 2115921.05690667 | 37.789855679639295 | -122.447431022041 | (37.7898556796393, -122.447431022041) | ||||
| 110784 | 110784 | 50673 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3305 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47252 | 5998970.56266258 | 2115921.05690667 | 37.789855679639295 | -122.447431022041 | (37.7898556796393, -122.447431022041) | ||||
| 67963 | 67963 | 220015 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 70 Quartz Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998973.5201 | 2099794.49518 | 37.745576384946 | -122.44626024553601 | (37.745576384946, -122.446260245536) | |||
| 139750 | 139750 | 39894 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 715 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1999 12:00:00 AM | Permit Number 41176 | 5999001.16721708 | 2108236.78492637 | 37.7687584031098 | -122.44677199136801 | (37.7687584031098, -122.446771991368) |
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");