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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 62900 | 62900 | 203646 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 45 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994072.18954 | 2100047.28757 | 37.745989350944 | -122.463226505408 | (37.745989350944, -122.463226505408) | |||
| 63361 | 63361 | 220063 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 930 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003095.90411 | 2102839.48353 | 37.75417177772871 | -122.432223106309 | (37.7541717777287, -122.432223106309) | |||
| 63850 | 63850 | 138348 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2499 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001613.9728 | 2114589.4995 | 37.786350268304 | -122.43818965646001 | (37.786350268304, -122.43818965646) | |||
| 64061 | 64061 | 32346 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 35th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37068 | 5985179.95256355 | 2107022.76154853 | 37.7646257968319 | -122.494488338591 | (37.7646257968319, -122.494488338591) | ||
| 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) | |||
| 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) | |||
| 64612 | 64612 | 103889 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Fulton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 5999356.4217 | 2110857.6178 | 37.7759748319201 | -122.44573169994499 | (37.7759748319201, -122.445731699945) | |||
| 64628 | 64628 | 71308 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1949 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1988 12:00:00 AM | 8 | 6000243.5 | 2111616.6716 | 37.7781096083019 | -122.44271758887699 | (37.7781096083019, -122.442717588877) | ||
| 65053 | 65053 | 37086 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1426 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39686 | 5981873.63686209 | 2105374.96731705 | 37.7599073668224 | -122.505801636192 | (37.7599073668224, -122.505801636192) | |
| 65145 | 65145 | 124758 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1513 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006956.23003 | 2117363.82528 | 37.79427026621129 | -122.419903713582 | (37.7942702662113, -122.419903713582) | |||
| 65413 | 65413 | 137613 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1502 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6001914.7987 | 2111556.8609 | 37.778040516588604 | -122.436931690487 | (37.7780405165886, -122.436931690487) | |||
| 65658 | 65658 | 183506 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2542 27th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5988021.6131 | 2097993.9577 | 37.7400010259161 | -122.483997786352 | (37.7400010259161, -122.483997786352) | |||
| 66468 | 66468 | 203632 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1400 Monterey Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5993831.29855 | 2094857.6984 | 37.7317261536347 | -122.463682879865 | (37.7317261536347, -122.463682879865) | |||
| 67640 | 67640 | 220077 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4160 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002637.75275 | 2104169.9909900003 | 37.7577990456928 | -122.433902601035 | (37.7577990456928, -122.433902601035) | |||
| 67828 | 67828 | 219994 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 49 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007506.429690001 | 2099145.6461 | 37.7442784195283 | -122.41670871553801 | (37.7442784195283, -122.416708715538) | |||
| 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) | |||
| 68064 | 68064 | 188520 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 495 Connecticut St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6013272.40757 | 2104812.59187 | 37.7601612472551 | -122.397168349564 | (37.7601612472551, -122.397168349564) | |||
| 68651 | 68651 | 220688 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 434 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004866.02058 | 2110397.15298 | 37.7750235387365 | -122.426639749043 | (37.7750235387365, -122.426639749043) | |||
| 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) | |||
| 68889 | 68889 | 220068 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3749 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003417.1638 | 2103582.09113 | 37.756229011985 | -122.43116511330601 | (37.756229011985, -122.431165113306) | |||
| 68937 | 68937 | 48447 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2600 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2002 12:00:00 AM | 8 | Permit Number 45819 | 5999656.5928 | 2113671.6674 | 37.783718621904896 | -122.44489566584998 | (37.7837186219049, -122.44489566585) | ||
| 69010 | 69010 | 188521 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 495 Connecticut St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6013271.447919999 | 2104826.1277799997 | 37.7601983604744 | -122.397172617724 | (37.7601983604744, -122.397172617724) | |||
| 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) | |||
| 69451 | 69451 | 38054 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2779 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/01/1999 12:00:00 AM | 7 | Permit Number 40250 | 6000242.4339 | 2114393.9483 | 37.7857352353713 | -122.442920768491 | (37.7857352353713, -122.442920768491) | |
| 69465 | 69465 | 188516 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1506 25th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6014137.77003 | 2102020.8067900003 | 37.7525437439982 | -122.39398001279301 | (37.7525437439982, -122.393980012793) | |||
| 69574 | 69574 | 245838 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 423 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6005012.6195 | 2110528.7961 | 37.7753932855436 | -122.426142005084 | (37.7753932855436, -122.426142005084) | |||
| 70197 | 70197 | 138347 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1770 SCOTT ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6001586.1357 | 2114554.9139 | 37.786253721877706 | -122.438283486898 | (37.7862537218777, -122.438283486898) | |||
| 70342 | 70342 | 220043 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 49 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6000611.236219999 | 2102612.95968 | 37.753408606731 | -122.440799429852 | (37.753408606731, -122.440799429852) | |||
| 70350 | 70350 | 35250 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1385 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 8 | Permit Number 38738 | 6006287.30636 | 2119683.41372 | 37.800601562682296 | -122.42238315976999 | (37.8006015626823, -122.42238315977) | |
| 70529 | 70529 | 138351 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2499 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001690.7359 | 2114600.4656 | 37.786384743909295 | -122.437924862001 | (37.7863847439093, -122.437924862001) | |||
| 70549 | 70549 | 40816 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1770 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1999 12:00:00 AM | 8 | Permit Number 41760 | 6001593.7276 | 2114497.5525 | 37.7860966539785 | -122.438253110129 | (37.7860966539785, -122.438253110129) | ||
| 70721 | 70721 | 245867 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 419 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005023.743 | 2110457.4751 | 37.775198084155605 | -122.42609844781799 | (37.7751980841556, -122.426098447818) | |||
| 72259 | 72259 | 220008 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3447 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006809.37202 | 2101432.95646 | 37.7505196263839 | -122.419281221778 | (37.7505196263839, -122.419281221778) | |||
| 72341 | 72341 | 220010 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3561 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006555.55006 | 2104341.3837900003 | 37.758491199927 | -122.420365369767 | (37.758491199927, -122.420365369767) | |||
| 72487 | 72487 | 249768 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 266 Lombard St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 6010977.12206 | 2120702.10235 | 37.8036620671076 | -122.406226211476 | (37.8036620671076, -122.406226211476) | |||
| 73601 | 73601 | 40189 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 600 Silliman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41375 | 6008978.52665 | 2093804.69628 | 37.7296960159571 | -122.411241285381 | (37.7296960159571, -122.411241285381) | ||
| 73916 | 73916 | 200693 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1607 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6015092.9345 | 2095762.8694 | 37.7354137854933 | -122.39023969268999 | (37.7354137854933, -122.39023969269) | |||
| 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) | |||
| 74936 | 74936 | 42897 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2016 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 7 | Permit Number 42813 | 5986657.8903 | 2096958.6583 | 37.737078880033 | -122.488636837876 | (37.737078880033, -122.488636837876) | |
| 74967 | 74967 | 124761 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1055 Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007856.93229 | 2119906.6476 | 37.8013029241584 | -122.41696742351101 | (37.8013029241584, -122.416967423511) | |||
| 75192 | 75192 | 220070 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 410 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003569.73703 | 2105814.1279 | 37.762366296795996 | -122.43079674288 | (37.762366296796, -122.43079674288) | |||
| 75193 | 75193 | 139501 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 750 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5999619.0371 | 2111147.3069 | 37.7767852347068 | -122.444844076108 | (37.7767852347068, -122.444844076108) | |||
| 75611 | 75611 | 182146 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1690 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5989681.6149 | 2103872.2722 | 37.756237834999 | -122.478688039412 | (37.756237834999, -122.478688039412) | |||
| 75622 | 75622 | 203667 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 100 Judson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5999360.3584 | 2093511.22392 | 37.7283460957947 | -122.444471133337 | (37.7283460957947, -122.444471133337) | |||
| 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) | |
| 76144 | 76144 | 220025 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4247 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6002149.21455 | 2101175.68513 | 37.7495496617103 | -122.435377979316 | (37.7495496617103, -122.435377979316) | |||
| 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) | |||
| 77394 | 77394 | 36576 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2959 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1998 12:00:00 AM | Permit Number 39438 | 6009743.48880831 | 2101591.28473575 | 37.7511191714417 | -122.409145947985 | (37.7511191714417, -122.409145947985) | ||
| 77508 | 77508 | 85510 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Nebraska St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 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) | ||||
| 77700 | 77700 | 37051 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 364 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39656 | 6003583.41460965 | 2098669.49042288 | 37.7427495797017 | -122.43023969551201 | (37.7427495797017, -122.430239695512) | ||
| 77854 | 77854 | 63851 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1233 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24548 | 6001965.88884277 | 2110471.51360831 | 37.775063328726 | -122.43667724183999 | (37.775063328726, -122.43667724184) | ||
| 78102 | 78102 | 32344 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 35th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37068 | 5985179.95256355 | 2107022.76154853 | 37.7646257968319 | -122.494488338591 | (37.7646257968319, -122.494488338591) | ||
| 78530 | 78530 | 42106 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 305 Hearst Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42409 | 5999382.77994639 | 2094344.80390055 | 37.730636191213996 | -122.444453504412 | (37.730636191214, -122.444453504412) | ||
| 79057 | 79057 | 32274 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 623 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39911 | 6007825.97257693 | 2096019.31993336 | 37.7357121847697 | -122.415382520688 | (37.7357121847697, -122.415382520688) | ||
| 79707 | 79707 | 46270 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 16 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/16/2002 12:00:00 AM | Permit Number 44554 | 6001971.15717323 | 2094954.12044598 | 37.732456582979495 | -122.435548678389 | (37.7324565829795, -122.435548678389) | ||
| 79886 | 79886 | 67804 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 215 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1994 12:00:00 AM | Permit Number 31453 | 6003763.62243652 | 2100965.95054031 | 37.7490653321175 | -122.429780349464 | (37.7490653321175, -122.429780349464) | ||
| 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) | ||
| 80404 | 80404 | 37853 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 639 Excelsior Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40143 | 6003947.74961722 | 2091786.98448726 | 37.723872400431496 | -122.428489463759 | (37.7238724004315, -122.428489463759) | ||
| 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) | ||
| 81201 | 81201 | 67531 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 55 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1992 12:00:00 AM | Permit Number 31069 | 6014000.26557437 | 2106870.40644282 | 37.765852048761104 | -122.394795132512 | (37.7658520487611, -122.394795132512) | ||
| 81412 | 81412 | 39503 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 216 Jersey St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40959 | 6003716.05884842 | 2101601.85489178 | 37.7508086831914 | -122.42999018002399 | (37.7508086831914, -122.429990180024) | ||
| 81631 | 81631 | 64135 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 674 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1992 12:00:00 AM | Permit Number 31501 | 6002183.05937143 | 2098884.5643421 | 37.7432607055203 | -122.43509709755399 | (37.7432607055203, -122.435097097554) | ||
| 81838 | 81838 | 35367 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 619 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | Permit Number 38827 | 6011631.49743277 | 2091601.49478662 | 37.723794911059606 | -122.401914809778 | (37.7237949110596, -122.401914809778) | ||
| 81874 | 81874 | 65160 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 878 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | Permit Number 27140 | 6000731.49768107 | 2102608.84071127 | 37.7534041452721 | -122.440383246008 | (37.7534041452721, -122.440383246008) | ||
| 81910 | 81910 | 42335 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 207 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42540 | 5999365.95160297 | 2094049.74226531 | 37.7298250607238 | -122.444490484515 | (37.7298250607238, -122.444490484515) | ||
| 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) | ||
| 82180 | 82180 | 120111 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 277 Clinton Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6004952.0 | 2108176.0 | 37.7689296510264 | -122.426184162815 | (37.7689296510264, -122.426184162815) | |||
| 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) | ||
| 82846 | 82846 | 63850 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1259 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24547 | 6001845.15733033 | 2110454.5773622 | 37.7750099641834 | -122.437093665021 | (37.7750099641834, -122.437093665021) | ||
| 83688 | 83688 | 42111 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 100 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42411 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
| 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) | ||
| 84208 | 84208 | 38069 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1654X SCOTT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40258 | 6001625.0 | 2114095.0 | 37.7849931264589 | -122.43811606926701 | (37.7849931264589, -122.438116069267) | |||
| 84795 | 84795 | 49477 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 560@ Pacific Davis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/2003 12:00:00 AM | Permit Number 46402 | 6013205.44581331 | 2118473.26826983 | 37.7976666140298 | -122.39835845145001 | (37.7976666140298, -122.39835845145) | |||
| 84909 | 84909 | 33582 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 157 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37690 | 6007165.20249785 | 2098095.43390853 | 37.741375573534896 | -122.41781418098302 | (37.7413755735349, -122.417814180983) | |||
| 84999 | 84999 | 87024 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 650 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49965 | 6001199.0 | 2102605.0 | 37.753420207362296 | -122.438766252724 | (37.7534202073623, -122.438766252724) | |||
| 85499 | 85499 | 35558 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 801 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38931 | 6005679.14966284 | 2104317.39620731 | 37.7583759105796 | -122.423394653078 | (37.7583759105796, -122.423394653078) | ||
| 85747 | 85747 | 39220 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1143 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41443 | 6005801.05573922 | 2102320.92573379 | 37.752900946135604 | -122.422831161336 | (37.7529009461356, -122.422831161336) | ||
| 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) | ||
| 85980 | 85980 | 61747 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3834 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2016 12:00:00 AM | 3 | Permit Number 21753 | 6004950.72602956 | 2100792.08081868 | 37.7486550770793 | -122.425662958373 | (37.7486550770793, -122.425662958373) | |
| 86084 | 86084 | 45525 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1700 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2001 12:00:00 AM | Permit Number 44286 | 5999707.83752219 | 2110208.85696406 | 37.7742135578008 | -122.444469428603 | (37.7742135578008, -122.444469428603) | |||
| 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) | |||
| 86248 | 86248 | 37317 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 576 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39832 | 6002608.13051852 | 2103294.09534049 | 37.7553923649469 | -122.433942439191 | (37.7553923649469, -122.433942439191) | ||
| 86515 | 86515 | 48833 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1019 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2002 12:00:00 AM | Permit Number 46053 | 6002516.40077061 | 2102618.9246623 | 37.7535333013465 | -122.43421140278099 | (37.7535333013465, -122.434211402781) | |||
| 86777 | 86777 | 38531 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1426 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/1998 12:00:00 AM | Permit Number 40513 | 6007984.37872155 | 2099748.42101744 | 37.74596037533 | -122.415098722892 | (37.74596037533, -122.415098722892) | ||
| 86884 | 86884 | 117033 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2220x SUTTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001781.0 | 2114465.0 | 37.786017922595605 | -122.437602866759 | (37.7860179225956, -122.437602866759) | ||||
| 87234 | 87234 | 61737 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 213 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/14/1993 12:00:00 AM | Permit Number 31452 | 6003775.93391522 | 2100966.602272 | 37.7490678187798 | -122.429737822747 | (37.7490678187798, -122.429737822747) | ||
| 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) | ||
| 87658 | 87658 | 67603 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 168 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1992 12:00:00 AM | Permit Number 31174 | 6013416.46891349 | 2106299.39948246 | 37.7642517131045 | -122.39677434216001 | (37.7642517131045, -122.39677434216) | ||
| 87712 | 87712 | 50320 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3615 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47024 | 6006189.66048824 | 2104317.6075576 | 37.7584052908739 | -122.421629093037 | (37.7584052908739, -122.421629093037) | |||
| 88063 | 88063 | 33257 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2669 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | Permit Number 37434 | 5986956.33101058 | 2097199.71207947 | 37.7377581609646 | -122.48762271062598 | (37.7377581609646, -122.487622710626) | ||
| 88150 | 88150 | 121723 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 199 Burnside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6001086.0 | 2095247.0 | 37.7332104486713 | -122.438629847451 | (37.7332104486713, -122.438629847451) | ||||
| 88327 | 88327 | 64256 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 191 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/1988 12:00:00 AM | Permit Number 25057 | 6004710.43221145 | 2098679.48425343 | 37.7428407913605 | -122.426343498945 | (37.7428407913605, -122.426343498945) | ||
| 88609 | 88609 | 67673 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1776 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | Permit Number 31276 | 6014200.74997189 | 2095090.82766105 | 37.733518969015996 | -122.393277319642 | (37.733518969016, -122.393277319642) | ||
| 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) | |||
| 88842 | 88842 | 66113 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 818 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1990 12:00:00 AM | Permit Number 29168 | 6003931.34560658 | 2110798.34494674 | 37.7760722269843 | -122.429901615557 | (37.7760722269843, -122.429901615557) | ||
| 88872 | 88872 | 84017 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1109 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50426 | 6002531.06648038 | 2102355.71188239 | 37.7528114140683 | -122.43414187071899 | (37.7528114140683, -122.434141870719) | ||
| 88925 | 88925 | 50661 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Santa Ynez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47244 | 6000978.87890111 | 2091807.60057831 | 37.723760552916296 | -122.43875382021002 | (37.7237605529163, -122.43875382021) | ||||
| 89217 | 89217 | 34443 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 65 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38187 | 6004317.14831895 | 2097838.60614012 | 37.740509693537504 | -122.427643467723 | (37.7405096935375, -122.427643467723) | ||
| 89262 | 89262 | 33122 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2363 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37356 | 6001608.80596075 | 2119029.55221322 | 37.798541206544705 | -122.438525775033 | (37.7985412065447, -122.438525775033) |
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");