trees
2,180 rows where qSpecies_id = 57 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6273 | 173900 | Private 9 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
10205 | 173902 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
11334 | 51578 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2005 12:00:00 AM | Permit Number 47872 | ||||||||||||||
14524 | 99746 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 4250 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | ||||||||||||||
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 | |
7918 | 129616 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6007378.23169 | 2111027.62658 | 37.7768963760054 | -122.417994148015 | (37.7768963760054, -122.417994148015) | 7 | 9 | 9 | 28852 | 36 | |||
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 | |||
21508 | 12295 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 845 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004849.7362 | 2111749.3214 | 37.7787353414927 | -122.426792396306 | (37.7787353414927, -122.426792396306) | 7 | 9 | 11 | 28852 | 41 | |||
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 | |||
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 | |||
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 | |||
56083 | 141960 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 873 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6004838.5689 | 2111828.9652 | 37.778953392387 | -122.426836701877 | (37.778953392387, -122.426836701877) | 7 | 9 | 11 | 28852 | 41 | |||
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 | |||
61099 | 142797 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 699 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6007064.6918 | 2113244.5216 | 37.7829657823409 | -122.419236076253 | (37.7829657823409, -122.419236076253) | 7 | 9 | 9 | 28852 | 36 | |||
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 | |||
75796 | 12296 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 853 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004840.61204 | 2111776.51991 | 37.7788095060362 | -122.426825897852 | (37.7788095060362, -122.426825897852) | 7 | 9 | 11 | 28852 | 41 | |||
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 | |||
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 | ||||
83444 | 12285 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 803X Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004627.99576 | 2111737.28964 | 37.7786897656705 | -122.427558625827 | (37.7786897656705, -122.427558625827) | 7 | 9 | 11 | 28852 | 41 | |||
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 | ||
99501 | 141959 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 881 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6004835.1064 | 2111857.5309 | 37.7790316310007 | -122.426850714982 | (37.7790316310007, -122.426850714982) | 7 | 9 | 11 | 28852 | 41 | |||
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 | |||
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 | |||
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 | ||||
113847 | 141962 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 853 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6004846.8495 | 2111778.1889 | 37.778814441339 | -122.426804438903 | (37.778814441339, -122.426804438903) | 7 | 9 | 11 | 28852 | 41 | |||
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 | |||
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 | |||
122656 | 12299 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 881 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004832.93645 | 2111868.25149 | 37.7790609444122 | -122.426858985423 | (37.7790609444122, -122.426858985423) | 7 | 9 | 11 | 28852 | 41 | |||
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 | |||
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 | ||
136602 | 141956 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 903 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6004778.5005 | 2111906.1319 | 37.7791618766611 | -122.427050000278 | (37.7791618766611, -122.427050000278) | 7 | 9 | 11 | 28852 | 41 | |||
139391 | 12298 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 869 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004833.39802 | 2111828.5317 | 37.778951909736 | -122.426854559148 | (37.778951909736, -122.426854559148) | 7 | 9 | 11 | 28852 | 41 | |||
143915 | 141967 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 801 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6004864.6208 | 2111645.3181 | 37.778450615538 | -122.42673349626 | (37.778450615538, -122.42673349626) | 7 | 9 | 11 | 28852 | 41 | |||
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 | |||
148764 | 12284 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 803X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004627.99576 | 2111737.28964 | 37.7786897656705 | -122.427558625827 | (37.7786897656705, -122.427558625827) | 7 | 9 | 11 | 28852 | 41 | |||
157963 | 141964 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 839 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004853.0777 | 2111718.4242 | 37.7786506943005 | -122.426778635822 | (37.7786506943005, -122.426778635822) | 7 | 9 | 11 | 28852 | 41 | |||
158045 | 141966 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 801 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004861.3228 | 2111665.6559 | 37.7785062716793 | -122.426746354001 | (37.7785062716793, -122.426746354001) | 7 | 9 | 11 | 28852 | 41 | |||
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 | |||
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 | ||||
167471 | 129617 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6007383.9261 | 2110990.71861 | 37.776795356048 | -122.417971832253 | (37.776795356048, -122.417971832253) | 7 | 9 | 9 | 28852 | 36 | |||
172313 | 12294 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 841X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004846.05575 | 2111737.27176 | 37.7787020480516 | -122.426804270071 | (37.7787020480516, -122.426804270071) | 7 | 9 | 11 | 28852 | 41 | |||
172480 | 12300 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 885 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004826.184 | 2111880.54348 | 37.7790943133977 | -122.426883220553 | (37.7790943133977, -122.426883220553) | 7 | 9 | 11 | 28852 | 41 | |||
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 | |||
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 | |||
182355 | 141958 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 889 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6004829.9126 | 2111886.0966 | 37.7791097717212 | -122.426870717393 | (37.7791097717212, -122.426870717393) | 7 | 9 | 11 | 28852 | 41 | |||
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 | |||
183933 | 37549 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 533 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39989 | 6009274.16052214 | 2114821.41225481 | 37.7874197302007 | -122.411703653187 | (37.7874197302007, -122.411703653187) | 5 | 1 | 10 | 28852 | 36 | ||
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 | |||
194010 | 120978 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 699X Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007023 | 2113270 | 37.7830333917519 | -122.419382121036 | (37.7830333917519, -122.419382121036) | 7 | 9 | 9 | 28852 | 36 | ||||
1280 | 191487 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 288 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010205.79697 | 2110974.44372 | 37.7769090816273 | -122.408208942312 | (37.7769090816273, -122.408208942312) | 8 | 2 | 9 | 28853 | 34 | |||
7612 | 15318 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006784.5559 | 2108731.4352 | 37.7705581530288 | -122.419884880101 | (37.7705581530288, -122.419884880101) | 8 | 2 | 9 | 28853 | 19 | |||
14133 | 226668 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 298 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008865.94709 | 2106940.47139 | 37.7657576213427 | -122.412558680646 | (37.7657576213427, -122.412558680646) | 8 | 4 | 7 | 28853 | 19 | |||
14552 | 226669 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 298 Alabama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008867.05744 | 2106924.30834 | 37.7657133036545 | -122.412553697512 | (37.7657133036545, -122.412553697512) | 8 | 4 | 7 | 28853 | 19 | |||
17473 | 201860 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1116 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010161.8818 | 2110817.0652 | 37.7764744978974 | -122.408349755778 | (37.7764744978974, -122.408349755778) | 8 | 2 | 9 | 28853 | 34 | |||
24120 | 103523 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 41X Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6006623 | 2109623 | 37.7729970743853 | -122.420507000439 | (37.7729970743853, -122.420507000439) | 8 | 2 | 9 | 28853 | 19 | |||
27217 | 191492 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 190 09th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008677.6339 | 2110340.84375 | 37.7750836791036 | -122.413450522147 | (37.7750836791036, -122.413450522147) | 8 | 2 | 9 | 28853 | 34 | |||
28121 | 113967 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 200 RHODE ISLAND ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011658 | 2107333 | 37.7669917162652 | -122.402929122897 | (37.7669917162652, -122.402929122897) | 8 | 2 | 8 | 28853 | 20 | ||||
28954 | 226671 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1340 Bryant St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 2ft | 6009364.61324 | 2107966.78389 | 37.7686036122904 | -122.410906387739 | (37.7686036122904, -122.410906387739) | 8 | 4 | 7 | 28853 | 19 | |||
29889 | 226699 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 38 Ramona Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 4ft | 6005184.56747 | 2107580.17464 | 37.767306799804 | -122.42533732116 | (37.767306799804, -122.42533732116) | 8 | 4 | 5 | 28853 | 19 | |||
30040 | 25706 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 582 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6012130.73474 | 2110269.98363 | 37.7750823930813 | -122.401500433298 | (37.7750823930813, -122.401500433298) | 14 | 2 | 9 | 28853 | 34 | |||
32673 | 226695 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005201.39938 | 2107761.16657 | 37.7678047112414 | -122.425291982748 | (37.7678047112414, -122.425291982748) | 8 | 4 | 5 | 28853 | 19 | |||
33284 | 226691 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 35 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005210.09814 | 2107610.98194 | 37.7673928316461 | -122.425251206571 | (37.7673928316461, -122.425251206571) | 8 | 4 | 5 | 28853 | 19 | |||
35183 | 15320 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2004 12:00:00 AM | 3 | 3X3 | 6006776.8374 | 2108697.9883 | 37.7704658809505 | -122.419909204722 | (37.7704658809505, -122.419909204722) | 8 | 2 | 9 | 28853 | 19 | ||
36185 | 226697 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 20 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005179.7337 | 2107663.13063 | 37.767534303997 | -122.425359944512 | (37.767534303997, -122.425359944512) | 8 | 4 | 5 | 28853 | 19 | |||
36939 | 226702 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1840 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005169.02744 | 2107248.98052 | 37.7663965419853 | -122.425367500632 | (37.7663965419853, -122.425367500632) | 8 | 4 | 5 | 28853 | 19 | |||
37883 | 191433 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 394 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011433.59566 | 2106622.69628 | 37.7650288494299 | -122.403655324029 | (37.7650288494299, -122.403655324029) | 8 | 3 | 8 | 28853 | 20 | |||
39167 | 227506 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 149 Otis St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6006716.29525 | 2108893.94632 | 37.7710005240788 | -122.420132529885 | (37.7710005240788, -122.420132529885) | 8 | 2 | 9 | 28853 | 19 | |||
39231 | 41268 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 44 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/1999 12:00:00 AM | Permit Number 41952 | 6006372.39336546 | 2109513.04186009 | 37.7726810295415 | -122.42136607091 | (37.7726810295415, -122.42136607091) | 8 | 2 | 9 | 28853 | 19 | |||
42683 | 226693 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 19 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005205.2228 | 2107708.26008 | 37.7676596586977 | -122.425274992744 | (37.7676596586977, -122.425274992744) | 8 | 4 | 5 | 28853 | 19 | |||
43925 | 112146 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 299X 05TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6011616 | 2112272 | 37.7805507327562 | -122.403421899857 | (37.7805507327562, -122.403421899857) | 6 | 2 | 9 | 28853 | 34 | |||
45757 | 201240 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 832 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6011987.3715 | 2112559.9702 | 37.7813621675722 | -122.402157393633 | (37.7813621675722, -122.402157393633) | 6 | 2 | 9 | 28853 | 34 | |||
47478 | 68437 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 190 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1993 12:00:00 AM | 22 | Permit Number 32291 | 6008616.38965 | 2110404.13314 | 37.7752540178903 | -122.413666857651 | (37.7752540178903, -122.413666857651) | 8 | 2 | 9 | 28853 | 34 | ||
53821 | 9998 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 122 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 6005390.2576582 | 2108319.0051408 | 37.7693470701553 | -122.424678431625 | (37.7693470701553, -122.424678431625) | 8 | 4 | 5 | 28853 | 19 | |||
55363 | 191486 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 347 Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011893.8519 | 2112710.62909 | 37.7817706214524 | -122.402491524862 | (37.7817706214524, -122.402491524862) | 6 | 2 | 9 | 28853 | 34 | |||
56278 | 227508 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 41 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6006644.81895 | 2109605.92162 | 37.7729514108221 | -122.420430313409 | (37.7729514108221, -122.420430313409) | 8 | 2 | 9 | 28853 | 19 | |||
57854 | 227510 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 37 Brady St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6006532.91743 | 2109718.55388 | 37.7732543654386 | -122.420825392799 | (37.7732543654386, -122.420825392799) | 8 | 2 | 9 | 28853 | 19 | |||
59530 | 101406 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 50-52 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2012 12:00:00 AM | 12 | 3x3 | Permit Number 769364 | 6005160.9 | 2107520.2 | 37.7671407866326 | -122.425414915098 | (37.7671407866326, -122.425414915098) | 8 | 4 | 5 | 28853 | 19 | |
60491 | 227507 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 78 Colton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006662.68149 | 2109606.33946 | 37.7729535646992 | -122.420368554271 | (37.7729535646992, -122.420368554271) | 8 | 2 | 9 | 28853 | 19 | |||
61550 | 61695 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 9 Ramona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1984 12:00:00 AM | Permit Number 21694 | 6005214.10969137 | 2107753.44919209 | 37.7677842392376 | -122.425247470035 | (37.7677842392376, -122.425247470035) | 8 | 4 | 5 | 28853 | 19 | ||
62433 | 25704 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 564 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6012091.3603 | 2110309.05533 | 37.7751874779549 | -122.401639385748 | (37.7751874779549, -122.401639385748) | 14 | 2 | 9 | 28853 | 34 | |||
62566 | 113965 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Rhode Island St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6011669.50654 | 2107216.87583 | 37.7666735080099 | -122.402881155253 | (37.7666735080099, -122.402881155253) | 8 | 2 | 8 | 28853 | 20 | |||
66394 | 201861 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1116 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010150.0088 | 2110807.2194 | 37.7764467987551 | -122.408390133412 | (37.7764467987551, -122.408390133412) | 8 | 2 | 9 | 28853 | 34 | |||
66593 | 112141 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 299 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6011568.52353 | 2112270.39261 | 37.7805436673854 | -122.403586031292 | (37.7805436673854, -122.403586031292) | 6 | 2 | 9 | 28853 | 34 | |||
67489 | 191489 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 190 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008631.45432 | 2110388.01646 | 37.7752106112282 | -122.41361360519 | (37.7752106112282, -122.41361360519) | 8 | 2 | 9 | 28853 | 34 | |||
67877 | 201858 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1114 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010186.2664 | 2110842.1371 | 37.7765447049461 | -122.408267170875 | (37.7765447049461, -122.408267170875) | 8 | 2 | 9 | 28853 | 34 | |||
68254 | 201859 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1114 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010175.6391 | 2110829.8748 | 37.7765104404434 | -122.408303068844 | (37.7765104404434, -122.408303068844) | 8 | 2 | 9 | 28853 | 34 | |||
70767 | 41267 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 44 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/1999 12:00:00 AM | Permit Number 41952 | 6006372.39336546 | 2109513.04186009 | 37.7726810295415 | -122.42136607091 | (37.7726810295415, -122.42136607091) | 8 | 2 | 9 | 28853 | 19 | |||
71624 | 113963 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Rhode Island St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2015 12:00:00 AM | 8 | 3x3 | 6011667.06303 | 2107250.97581 | 37.7667670024209 | -122.402892005557 | (37.7667670024209, -122.402892005557) | 8 | 2 | 8 | 28853 | 20 | ||
71764 | 15341 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1735 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6006768.902 | 2108274.3401 | 37.7693021964753 | -122.419906586242 | (37.7693021964753, -122.419906586242) | 8 | 4 | 7 | 28853 | 19 | |||
71975 | 63893 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1X BRADY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1987 12:00:00 AM | Permit Number 24602 | 6006435 | 2109828 | 37.7735493586958 | -122.421171875993 | (37.7735493586958, -122.421171875993) | 8 | 2 | 9 | 28853 | 19 |
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) );