trees
2,180 rows where qSpecies_id = 57 sorted by Neighborhoods (old)
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
180827 | 177075 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 601 Blanken Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6013151.42883 | 2086913.13616 | 37.711006322265 | -122.396332172488 | (37.711006322265, -122.396332172488) | 10 | 3 | 8 | 309 | 1 | |||
183264 | 12175 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1413X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016419.0642 | 2095079.8835 | 37.7336119107928 | -122.385607138859 | (37.7336119107928, -122.385607138859) | 10 | 3 | 8 | 58 | 1 | |||
184036 | 12181 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1401X La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016385.1563 | 2095160.2578 | 37.7338307263114 | -122.385729969415 | (37.7338307263114, -122.385729969415) | 10 | 3 | 8 | 58 | 1 | |||
184435 | 191450 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1298 Fairfax Ave | 7 | : | Tree | Private 2 | 6 | Width 3ft | 6017131.85969 | 2097105.51243 | 37.7392132974473 | -122.383283724566 | (37.7392132974473, -122.383283724566) | 10 | 3 | 8 | 58 | 1 | |||
186770 | 200629 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1433 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016516.3925 | 2094928.5537 | 37.7332017742072 | -122.385260102357 | (37.7332017742072, -122.385260102357) | 10 | 3 | 8 | 58 | 1 | |||
188349 | 12174 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1415X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6016429.111 | 2095062.9295 | 37.7335659143966 | -122.385571222674 | (37.7335659143966, -122.385571222674) | 10 | 3 | 8 | 58 | 1 | |||
189254 | 31669 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 301 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/1995 12:00:00 AM | Permit Number 35177 | 6012138.91947495 | 2087210.17556421 | 37.7117655390688 | -122.399852513423 | (37.7117655390688, -122.399852513423) | 10 | 3 | 8 | 309 | 1 | |||
189400 | 12214 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1505 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6015992.7036 | 2095777.5074 | 37.735503845269 | -122.38712984693 | (37.735503845269, -122.38712984693) | 10 | 3 | 8 | 58 | 1 | |||
189764 | 200059 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1801 Lane St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 0ft | 6014873.6392 | 2094076.1095 | 37.7307701187384 | -122.390880037484 | (37.7307701187384, -122.390880037484) | 10 | 3 | 8 | 58 | 1 | |||
190969 | 12205 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1365X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.384587939042 | (37.7327261850679, -122.384587939042) | 10 | 3 | 8 | 58 | 1 | |||
192329 | 200062 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1801 Lane St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6014902.219 | 2094116.2312 | 37.7308818705774 | -122.390784034613 | (37.7308818705774, -122.390784034613) | 10 | 3 | 8 | 58 | 1 | |||
193717 | 17143 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1030 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/1999 12:00:00 AM | 3 | 3X3 | 6018053.0176703 | 2093253.3980264 | 37.7286870123052 | -122.379831166827 | (37.7286870123052, -122.379831166827) | 10 | 3 | 8 | 58 | 1 | ||
193836 | 12192 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1465 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016272.6778818 | 2095480.4561364 | 37.7347037020974 | -122.386141159163 | (37.7347037020974, -122.386141159163) | 10 | 3 | 8 | 58 | 1 | |||
193927 | 6754 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1215 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1992 12:00:00 AM | 8 | 3x3 | 6017521.0990665 | 2096743.3718322 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | 10 | 3 | 8 | 58 | 1 | ||
4618 | 31345 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 270 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 10 | Permit Number 34956 | 6006088.23081 | 2111255.80978 | 37.7774502243821 | -122.422472877923 | (37.7774502243821, -122.422472877923) | 7 | 9 | 11 | 28852 | 10 | |
7768 | 227479 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 245 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003729.95896 | 2109287.50824 | 37.7719124339341 | -122.430490439197 | (37.7719124339341, -122.430490439197) | 15 | 9 | 11 | 29492 | 10 | |||
12926 | 141575 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1478 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000744.6746 | 2110704.0393 | 37.7756323088735 | -122.440918362809 | (37.7756323088735, -122.440918362809) | 15 | 5 | 11 | 29492 | 10 | |||
15127 | 103601 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | |||
18638 | 60588 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 516 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 12 | Permit Number 20205 | 6000644.6678 | 2110770.9269 | 37.7758102690094 | -122.441269110246 | (37.7758102690094, -122.441269110246) | 15 | 5 | 11 | 29492 | 10 | |
22447 | 227487 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 363 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003972.26213 | 2109022.08762 | 37.7711973766861 | -122.429633361902 | (37.7711973766861, -122.429633361902) | 7 | 9 | 11 | 29492 | 10 | |||
23340 | 226753 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 386 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004702.0529 | 2110024.96112 | 37.7739923194146 | -122.427180432244 | (37.7739923194146, -122.427180432244) | 7 | 9 | 11 | 28852 | 10 | |||
23747 | 115658 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1499X HAYES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6000749 | 2110266 | 37.7744298099173 | -122.440871970116 | (37.7744298099173, -122.440871970116) | 15 | 5 | 11 | 29492 | 10 | |||
25460 | 227484 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 233 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003739.20839 | 2109215.47693 | 37.7717151775349 | -122.43045330438 | (37.7717151775349, -122.43045330438) | 15 | 9 | 11 | 29492 | 10 | |||
28646 | 42768 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 837 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 5 | Permit Number 42744 | 6003836.146 | 2110735.9706 | 37.7758955707266 | -122.430226485287 | (37.7758955707266, -122.430226485287) | 7 | 9 | 11 | 29492 | 10 | ||
29208 | 142175 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1470 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6000827.8368 | 2110365.1539 | 37.7747065511696 | -122.440606372757 | (37.7747065511696, -122.440606372757) | 15 | 5 | 11 | 29492 | 10 | |||
34804 | 141375 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 340 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6000736.9149 | 2110161.46 | 37.7741420811546 | -122.440906273714 | (37.7741420811546, -122.440906273714) | 15 | 5 | 11 | 29492 | 10 | |||
34919 | 17038 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1200X Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001065.34359 | 2109713.09337 | 37.7729296786885 | -122.43973803201 | (37.7729296786885, -122.43973803201) | 15 | 5 | 11 | 29492 | 10 | |||
40930 | 103608 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | |||
41442 | 35152 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 265 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | Permit Number 38683 | 6003463.92079467 | 2109118.95080504 | 37.7714345424169 | -122.431398649315 | (37.7714345424169, -122.431398649315) | 15 | 9 | 11 | 29492 | 10 | ||
44846 | 129615 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 211 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006279.39268 | 2111260.53143 | 37.7774739709929 | -122.421811920298 | (37.7774739709929, -122.421811920298) | 7 | 9 | 11 | 28852 | 10 | |||
44926 | 103602 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | |||
53690 | 103610 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 200X Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | 7 | 9 | 5 | 28852 | 10 | ||||
53881 | 254253 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 601 Grove St | 1 | Front Yard : Yard | Tree | Private 2 | 6004708 | 2111182 | 37.777169601607 | -122.427242295103 | (37.777169601607, -122.427242295103) | 7 | 9 | 11 | 28852 | 10 | |||||
55440 | 141422 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 550 IVY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004543.5906 | 2111042.8919 | 37.7767783457628 | -122.42780112527 | (37.7767783457628, -122.42780112527) | 7 | 9 | 11 | 28852 | 10 | |||
56899 | 226665 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 201 Buchanan St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6004711.01966 | 2109215.80754 | 37.7717710874854 | -122.427091769887 | (37.7717710874854, -122.427091769887) | 7 | 9 | 11 | 28852 | 10 | |||
61473 | 141360 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1499X Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6000919 | 2110350 | 37.7746701332237 | -122.440289934591 | (37.7746701332237, -122.440289934591) | 15 | 5 | 11 | 29492 | 10 | |||
63587 | 114459 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1455 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6000893.3376 | 2110327.3177 | 37.7746063922099 | -122.440377078704 | (37.7746063922099, -122.440377078704) | 15 | 5 | 11 | 29492 | 10 | |||
64257 | 227480 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 247 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003730.80574 | 2109266.10983 | 37.7718537271043 | -122.430485983041 | (37.7718537271043, -122.430485983041) | 15 | 9 | 11 | 29492 | 10 | |||
65331 | 141578 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 500 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6000652.8634 | 2110721.5192 | 37.7756750748217 | -122.441237213894 | (37.7756750748217, -122.441237213894) | 15 | 5 | 11 | 29492 | 10 | |||
65923 | 141361 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1499X Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6000919 | 2110350 | 37.7746701332237 | -122.440289934591 | (37.7746701332237, -122.440289934591) | 15 | 5 | 11 | 29492 | 10 | |||
66513 | 226752 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 188 Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6004776.27473 | 2109101.09065 | 37.7714597925537 | -122.426857876903 | (37.7714597925537, -122.426857876903) | 7 | 9 | 5 | 28852 | 10 | |||
68439 | 99103 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 201 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006380 | 2111267.6 | 37.7774990526419 | -122.421464387784 | (37.7774990526419, -122.421464387784) | 7 | 9 | 11 | 28852 | 10 | ||||
69727 | 226663 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 109 Buchanan St | 2 | : | Tree | Private 2 | 10 | Width 4ft | 6004754.99125 | 2108900.44461 | 37.7709076637003 | -122.426917205171 | (37.7709076637003, -122.426917205171) | 7 | 9 | 11 | 28852 | 10 | |||
75510 | 141577 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1470 Grove St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6000705.689 | 2110697.4418 | 37.7756119733478 | -122.44105274979 | (37.7756119733478, -122.44105274979) | 15 | 5 | 11 | 29492 | 10 | |||
75514 | 58120 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 839 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/20/1999 12:00:00 AM | Permit Number 17101 | 6003847.07815842 | 2110734.06414103 | 37.7758909552538 | -122.430188532102 | (37.7758909552538, -122.430188532102) | 7 | 9 | 11 | 29492 | 10 | ||
76453 | 227477 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004706.62756 | 2109170.30594 | 37.7716459027615 | -122.42710372096 | (37.7716459027615, -122.42710372096) | 7 | 9 | 11 | 28852 | 10 | |||
77770 | 115659 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1499X HAYES ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6000749 | 2110266 | 37.7744298099173 | -122.440871970116 | (37.7744298099173, -122.440871970116) | 15 | 5 | 11 | 29492 | 10 | |||
81722 | 103609 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 200X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | 7 | 9 | 5 | 28852 | 10 | ||||
84350 | 114458 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1455 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6000876.4539 | 2110325.3314 | 37.7745999769916 | -122.440435340128 | (37.7745999769916, -122.440435340128) | 15 | 5 | 11 | 29492 | 10 | |||
92866 | 226666 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 201 Buchanan St | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6004707.88321 | 2109244.50494 | 37.7718497062225 | -122.427104663459 | (37.7718497062225, -122.427104663459) | 7 | 9 | 11 | 28852 | 10 | |||
95153 | 226750 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 188 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6004784.115 | 2109030.20861 | 37.7712656109374 | -122.426825708165 | (37.7712656109374, -122.426825708165) | 7 | 9 | 5 | 28852 | 10 | |||
95772 | 244979 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 277 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005281.1392 | 2109733.1104 | 37.773223698864 | -122.425156502197 | (37.773223698864, -122.425156502197) | 7 | 9 | 11 | 28852 | 10 | |||
97966 | 103603 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | ||
98330 | 142177 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1490 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000750.4323 | 2110355.4784 | 37.7746755766034 | -122.44087343567 | (37.7746755766034, -122.44087343567) | 15 | 5 | 11 | 29492 | 10 | |||
104660 | 226751 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 188 Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6004780.64342 | 2109066.90336 | 37.7713661695481 | -122.426840330241 | (37.7713661695481, -122.426840330241) | 7 | 9 | 5 | 28852 | 10 | |||
105214 | 227478 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 245 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003726.38688 | 2109301.69364 | 37.7719511812193 | -122.430503807617 | (37.7719511812193, -122.430503807617) | 15 | 9 | 11 | 29492 | 10 | |||
106578 | 227489 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 363 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004002.39724 | 2109025.74245 | 37.7712091182481 | -122.429529384082 | (37.7712091182481, -122.429529384082) | 7 | 9 | 11 | 29492 | 10 | |||
107270 | 226748 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004804.20334 | 2108897.19386 | 37.7709015204117 | -122.42674674767 | (37.7709015204117, -122.42674674767) | 7 | 9 | 5 | 28852 | 10 | |||
107807 | 103607 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | |||
109271 | 227482 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 239 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003735.01084 | 2109245.29293 | 37.7717968071986 | -122.430469951741 | (37.7717968071986, -122.430469951741) | 15 | 9 | 11 | 29492 | 10 | |||
111173 | 227483 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 237 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003736.51257 | 2109230.49944 | 37.7717562729627 | -122.430463701445 | (37.7717562729627, -122.430463701445) | 15 | 9 | 11 | 29492 | 10 | |||
112331 | 103606 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | ||||
114397 | 66457 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 441 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29607 | 6004072.71052571 | 2110301.27189775 | 37.7747153911121 | -122.429377141824 | (37.7747153911121, -122.429377141824) | 7 | 9 | 11 | 29492 | 10 | ||
115155 | 103605 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | |||
117551 | 227481 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 247 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003735.63244 | 2109254.6164 | 37.7718224423784 | -122.430468466942 | (37.7718224423784, -122.430468466942) | 15 | 9 | 11 | 29492 | 10 | |||
121302 | 244959 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 202 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005168.0947 | 2109754.9899 | 37.7732773879685 | -122.425549095959 | (37.7732773879685, -122.425549095959) | 7 | 9 | 11 | 28852 | 10 | |||
125739 | 226667 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 201 Buchanan St | 4 | : | Tree | Private 2 | 8 | Width 3ft | 6004704.09472 | 2109267.38309 | 37.7719123098365 | -122.42711939795 | (37.7719123098365, -122.42711939795) | 7 | 9 | 11 | 28852 | 10 | |||
125859 | 32770 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 372 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 7 | Permit Number 37143 | 6000719.0381 | 2110275.1768 | 37.7744533006426 | -122.440976272213 | (37.7744533006426, -122.440976272213) | 15 | 5 | 11 | 29492 | 10 | |
126147 | 103604 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | ||
132761 | 61040 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 237 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1986 12:00:00 AM | Permit Number 20864 | 6003739.14918424 | 2109203.826412 | 37.771683184708 | -122.430452677761 | (37.771683184708, -122.430452677761) | 15 | 9 | 11 | 29492 | 10 | ||
132774 | 227486 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 225 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6003747.47906 | 2109158.43238 | 37.7715590156536 | -122.430420624821 | (37.7715590156536, -122.430420624821) | 15 | 9 | 11 | 29492 | 10 | |||
134901 | 141369 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 340 BAKER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6000731.4526 | 2110189.2685 | 37.7742181251853 | -122.440927164049 | (37.7742181251853, -122.440927164049) | 15 | 5 | 11 | 29492 | 10 | |||
135157 | 141376 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 340 BAKER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000731.9492 | 2110174.3711 | 37.7741772489645 | -122.440924377301 | (37.7741772489645, -122.440924377301) | 15 | 5 | 11 | 29492 | 10 | |||
135159 | 32769 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 372 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 6 | Permit Number 37143 | 6000722.0176 | 2110255.3136 | 37.7743989310052 | -122.440964540315 | (37.7743989310052, -122.440964540315) | 15 | 5 | 11 | 29492 | 10 | |
144219 | 226664 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 201 Buchanan St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6004714.27593 | 2109192.94036 | 37.7717084838914 | -122.427078877212 | (37.7717084838914, -122.427078877212) | 7 | 9 | 11 | 28852 | 10 | |||
158839 | 141574 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1470 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6000762.6679 | 2110707.638 | 37.7756432147662 | -122.440856377939 | (37.7756432147662, -122.440856377939) | 15 | 5 | 11 | 29492 | 10 | |||
159394 | 244961 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 202 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005161.4093 | 2109786.5938 | 37.7733637868695 | -122.425574471379 | (37.7733637868695, -122.425574471379) | 7 | 9 | 11 | 28852 | 10 | |||
160905 | 227485 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 263 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003471.8056 | 2109138.4635 | 37.7714885663619 | -122.431372768533 | (37.7714885663619, -122.431372768533) | 15 | 9 | 11 | 29492 | 10 | |||
165665 | 16954 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 660 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003830.0479 | 2110098.0565 | 37.7741436701635 | -122.430202060124 | (37.7741436701635, -122.430202060124) | 7 | 9 | 11 | 29492 | 10 | |||
165711 | 122685 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 270 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006053 | 2111262 | 37.7774652336961 | -122.422595193091 | (37.7774652336961, -122.422595193091) | 7 | 9 | 11 | 28852 | 10 | ||||
166069 | 141576 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1480 Grove St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6000723.6824 | 2110698.6413 | 37.7756162917204 | -122.440990592453 | (37.7756162917204, -122.440990592453) | 15 | 5 | 11 | 29492 | 10 | |||
175029 | 244960 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 202 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005166.2714 | 2109775.654 | 37.7733340235563 | -122.425556873948 | (37.7733340235563, -122.425556873948) | 7 | 9 | 11 | 28852 | 10 | |||
177499 | 142176 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1480 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000776.2338 | 2110357.6285 | 37.7746829496642 | -122.44078433759 | (37.7746829496642, -122.44078433759) | 15 | 5 | 11 | 29492 | 10 | |||
181485 | 226662 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 109 Buchanan St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6004759.39323 | 2108882.79631 | 37.7708594546408 | -122.426900721499 | (37.7708594546408, -122.426900721499) | 7 | 9 | 11 | 28852 | 10 | |||
182509 | 226747 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004809.8918 | 2108865.505 | 37.7708148320814 | -122.426724814115 | (37.7708148320814, -122.426724814115) | 7 | 9 | 5 | 28852 | 10 | |||
185483 | 32771 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 372 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37143 | 6000720.14986856 | 2110226.00515194 | 37.7743183510223 | -122.440968898129 | (37.7743183510223, -122.440968898129) | 15 | 5 | 11 | 29492 | 10 | ||
186253 | 226749 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 188 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6004787.62152 | 2108995.19732 | 37.7711696766722 | -122.426811085178 | (37.7711696766722, -122.426811085178) | 7 | 9 | 5 | 28852 | 10 | |||
188857 | 227488 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 363 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003985.98908 | 2109021.37679 | 37.7711962021697 | -122.429585829147 | (37.7711962021697, -122.429585829147) | 7 | 9 | 11 | 29492 | 10 | |||
189896 | 17040 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1200X Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001235.1914802 | 2109729.1714048 | 37.7729834911046 | -122.439151661694 | (37.7729834911046, -122.439151661694) | 15 | 5 | 11 | 29492 | 10 | |||
192971 | 64518 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 512 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/21/1988 12:00:00 AM | Permit Number 25400 | 6000652.29265662 | 2110712.76052634 | 37.7756509932088 | -122.441238559661 | (37.7756509932088, -122.441238559661) | 15 | 5 | 11 | 29492 | 10 | ||
13359 | 32006 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1516 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/1995 12:00:00 AM | 12 | 6x7 | Permit Number 35401 | 5993964.99651 | 2112129.18726 | 37.779156921599 | -122.464474250231 | (37.779156921599, -122.464474250231) | 11 | 6 | 2 | 54 | 11 | |
13747 | 59130 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 555 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1980 12:00:00 AM | 10 | Permit Number 18435 | 5992502.82437 | 2111669.37553 | 37.7778100081451 | -122.469498976775 | (37.7778100081451, -122.469498976775) | 11 | 6 | 2 | 54 | 11 | |
22007 | 59094 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 627 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1980 12:00:00 AM | 11 | Permit Number 18395 | 5994067.68279 | 2111215.68706 | 37.7766546137994 | -122.464052687917 | (37.7766546137994, -122.464052687917) | 11 | 6 | 2 | 54 | 11 | ||
22285 | 123213 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 598 09th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5993174.18486 | 2111497.33118 | 37.7773763974687 | -122.4671640155 | (37.7773763974687, -122.4671640155) | 11 | 6 | 2 | 54 | 11 | |||
49475 | 59083 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 771 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1980 12:00:00 AM | 5 | Permit Number 18384 | 5993309.0611 | 2110688.13822 | 37.7751623558712 | -122.466638605274 | (37.7751623558712, -122.466638605274) | 11 | 6 | 2 | 54 | 11 | ||
54511 | 54972 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 566 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/1972 12:00:00 AM | 6 | Permit Number 10850 | 5993167.80769 | 2111626.89496 | 37.7777317765261 | -122.467195498751 | (37.7777317765261, -122.467195498751) | 11 | 6 | 2 | 54 | 11 | ||
69017 | 123214 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 598 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5993175.31318 | 2111469.83533 | 37.7773009664124 | -122.467158112666 | (37.7773009664124, -122.467158112666) | 11 | 6 | 2 | 54 | 11 | |||
77183 | 123768 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 801 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5993093.8736 | 2110681.87789 | 37.7751327461839 | -122.467382525307 | (37.7751327461839, -122.467382525307) | 11 | 6 | 2 | 54 | 11 | |||
77699 | 59243 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 844 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1980 12:00:00 AM | 13 | Permit Number 18574 | 5992945.97029 | 2110731.04138 | 37.7752591962743 | -122.467897727976 | (37.7752591962743, -122.467897727976) | 11 | 6 | 2 | 54 | 11 | ||
88279 | 59227 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 801 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/1980 12:00:00 AM | 8 | Permit Number 18548 | 5993132.18227 | 2110683.6114 | 37.7751397174352 | -122.467250134298 | (37.7751397174352, -122.467250134298) | 11 | 6 | 2 | 54 | 11 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );