trees
3,709 rows where qSpecies_id = 9 sorted by Location descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
152277 | 131962 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2753 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/1997 12:00:00 AM | 5 | Width 3ft | 6006843.61903 | 2121816.35124 | 37.806489432204 | -122.420609582486 | (37.806489432204, -122.420609582486) | 5 | 1 | 1 | 28858 | 32 | ||
154774 | 131963 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2753 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 3ft | 6006844.59432 | 2121791.39678 | 37.8064209686093 | -122.420604434741 | (37.8064209686093, -122.420604434741) | 5 | 1 | 1 | 28858 | 32 | |||
39137 | 11183 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2765 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/1997 12:00:00 AM | 12 | 3X3 | 6006851.5978528 | 2121751.8788051 | 37.8063128570627 | -122.420577390706 | (37.8063128570627, -122.420577390706) | 5 | 1 | 1 | 28858 | 32 | ||
98064 | 11184 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2765 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6006851.5978528 | 2121751.8788051 | 37.8063128570627 | -122.420577390706 | (37.8063128570627, -122.420577390706) | 5 | 1 | 1 | 28858 | 32 | |||
143445 | 131874 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 295 Marina Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 6002038.91196 | 2121849.60525 | 37.8063087844798 | -122.437239504003 | (37.8063087844798, -122.437239504003) | 13 | 9 | 1 | 57 | 17 | |||
1842 | 11178 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2741 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6006856.2652 | 2121744.00393 | 37.8062914977061 | -122.420560679149 | (37.8062914977061, -122.420560679149) | 5 | 1 | 1 | 28858 | 32 | |||
16856 | 11172 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2717 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6006856.95142 | 2121692.8865 | 37.8061511809927 | -122.420554673483 | (37.8061511809927, -122.420554673483) | 5 | 1 | 1 | 28858 | 32 | |||
95330 | 11171 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2714 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 3X3 | 6006919.28151 | 2121625.44427 | 37.8059695143526 | -122.420334179488 | (37.8059695143526, -122.420334179488) | 5 | 1 | 1 | 28858 | 32 | |||
183018 | 11170 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2706 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6006921.64786 | 2121607.86712 | 37.805921385333 | -122.42032474199 | (37.805921385333, -122.42032474199) | 5 | 1 | 1 | 28858 | 32 | |||
32861 | 11174 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2721 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6006871.9159428 | 2121607.3582758 | 37.8059171856884 | -122.420496811264 | (37.8059171856884, -122.420496811264) | 5 | 1 | 1 | 28858 | 32 | |||
148513 | 131873 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 435 Marina Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6001088.51978 | 2121715.49846 | 37.8058864916338 | -122.440518869269 | (37.8058864916338, -122.440518869269) | 13 | 9 | 1 | 57 | 17 | ||||
89322 | 11169 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2700 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6006924.13035 | 2121583.86925 | 37.8058556331999 | -122.420314446577 | (37.8058556331999, -122.420314446577) | 5 | 1 | 1 | 28858 | 32 | |||
128184 | 131872 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 475 Marina Blvd | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 2ft | 6000857.63079 | 2121697.12511 | 37.805822893385 | -122.441316575098 | (37.805822893385, -122.441316575098) | 13 | 9 | 1 | 57 | 17 | |||
97352 | 131871 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 475 Marina Blvd | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 2ft | 6000836.15896 | 2121693.63297 | 37.8058120817332 | -122.441390630693 | (37.8058120817332, -122.441390630693) | 13 | 9 | 1 | 57 | 17 | |||
142720 | 112712 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 416 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008783.11467 | 2121477.20046 | 37.8056673241578 | -122.413873574 | (37.8056673241578, -122.413873574) | 3 | 1 | 10 | 308 | 23 | |||
125249 | 112713 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 416 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008763.59145 | 2121474.42141 | 37.80565859714 | -122.41394094044 | (37.80565859714, -122.41394094044) | 3 | 1 | 10 | 308 | 23 | |||
20724 | 112714 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 416 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6008746.75593 | 2121471.08922 | 37.8056485022522 | -122.413998966505 | (37.8056485022522, -122.413998966505) | 3 | 1 | 10 | 308 | 23 | |||
114579 | 87735 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3200X Van Ness Ave | 7 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005457.064 | 2121526.81323 | 37.8056161950061 | -122.425387396305 | (37.8056161950061, -122.425387396305) | 5 | 1 | 1 | 28858 | 32 | ||
189066 | 131968 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2654 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006939.68178 | 2121495.98775 | 37.805615209341 | -122.420254387139 | (37.805615209341, -122.420254387139) | 5 | 1 | 1 | 28858 | 32 | |||
171964 | 131866 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 555 Marina Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6000334.74544 | 2121624.79375 | 37.805594490755 | -122.443120895728 | (37.805594490755, -122.443120895728) | 13 | 9 | 1 | 57 | 17 | |||
23768 | 131865 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 555 Marina Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 6000313.87819 | 2121622.81545 | 37.8055878690403 | -122.443192967399 | (37.8055878690403, -122.443192967399) | 13 | 9 | 1 | 57 | 17 | |||
102942 | 11165 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2655 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006893.18193 | 2121482.83945 | 37.8055764872155 | -122.42041437295 | (37.8055764872155, -122.42041437295) | 5 | 1 | 1 | 28858 | 32 | |||
117137 | 11164 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2650 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6006942.2149 | 2121476.64604 | 37.8055622446775 | -122.42024424729 | (37.8055622446775, -122.42024424729) | 5 | 1 | 1 | 28858 | 32 | |||
110068 | 131875 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1445 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6002295.77792 | 2121559.23288 | 37.8055260973233 | -122.43632978131 | (37.8055260973233, -122.43632978131) | 13 | 9 | 1 | 57 | 17 | |||
3058 | 11168 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2666 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 3X3 | 6006944.2763295 | 2121452.6056321 | 37.8054963520093 | -122.420235406119 | (37.8054963520093, -122.420235406119) | 5 | 1 | 1 | 28858 | 32 | |||
76276 | 11166 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2655 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6006897.54428 | 2121449.51941 | 37.8054852447207 | -122.420396909886 | (37.8054852447207, -122.420396909886) | 5 | 1 | 1 | 28858 | 32 | |||
183912 | 11163 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2646 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6006947.21164 | 2121442.50233 | 37.8054687763153 | -122.420224530547 | (37.8054687763153, -122.420224530547) | 5 | 1 | 1 | 28858 | 32 | |||
70258 | 87733 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3200X Van Ness Ave | 5 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005465.59287 | 2121464.41753 | 37.8054453543938 | -122.425353437905 | (37.8054453543938, -122.425353437905) | 5 | 1 | 1 | 28858 | 32 | ||
93468 | 11167 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2655 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3X3 | 6006899.01173 | 2121433.76541 | 37.805442070952 | -122.420390712665 | (37.805442070952, -122.420390712665) | 5 | 1 | 1 | 28858 | 32 | |||
115942 | 87887 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3750 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50857 | 6002559.44866 | 2121515.2507 | 37.8054203118567 | -122.435414165341 | (37.8054203118567, -122.435414165341) | 13 | 9 | 1 | 57 | 17 | |
163098 | 131967 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2642 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6006948.59932 | 2121422.85954 | 37.8054149204178 | -122.420218333313 | (37.8054149204178, -122.420218333313) | 5 | 1 | 1 | 28858 | 32 | |||
9726 | 87886 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3750 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50857 | 6002562.15931 | 2121499.01412 | 37.8053758844436 | -122.4354036226 | (37.8053758844436, -122.4354036226) | 13 | 9 | 1 | 57 | 17 | |
76145 | 87732 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3200X Van Ness Ave | 4 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005468.85489 | 2121438.02655 | 37.8053730758726 | -122.425340270033 | (37.8053730758726, -122.425340270033) | 5 | 1 | 1 | 28858 | 32 | ||
124108 | 258218 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 1000 North Point St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6005937.91741 | 2121414.48699 | 37.8053349315385 | -122.423715341013 | (37.8053349315385, -122.423715341013) | 5 | 1 | 1 | 28858 | 32 | |||||
103345 | 87885 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3750 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50857 | 6002564.08274 | 2121481.52987 | 37.8053279865497 | -122.435395714839 | (37.8053279865497, -122.435395714839) | 13 | 9 | 1 | 57 | 17 | |
172291 | 11162 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2640 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006953.5572074 | 2121387.1992739 | 37.8053172857834 | -122.420198643397 | (37.8053172857834, -122.420198643397) | 5 | 1 | 1 | 28858 | 32 | |||
102723 | 11161 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2638 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6006954.2638733 | 2121382.2190943 | 37.8053036512983 | -122.420195844212 | (37.8053036512983, -122.420195844212) | 5 | 1 | 1 | 28858 | 32 | |||
182301 | 11160 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2632 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6006954.37609 | 2121379.1362 | 37.80529519278 | -122.420195236936 | (37.80529519278, -122.420195236936) | 5 | 1 | 1 | 28858 | 32 | |||
93101 | 251659 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 1050 North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6005628 | 2121390 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | 5 | 1 | 1 | 28858 | 32 | ||||
143771 | 251658 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 1050 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6005628 | 2121390 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | 5 | 1 | 1 | 28858 | 32 | ||||
178107 | 251661 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 3200X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6005628 | 2121390 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | 5 | 1 | 1 | 28858 | 32 | ||||
194367 | 56573 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 250 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2019 12:00:00 AM | 3 | 5x5 | 6010068.531 | 2121298.26 | 37.8052481034096 | -122.409412549107 | (37.8052481034096, -122.409412549107) | 3 | 1 | 10 | 308 | 23 | ||
104593 | 11158 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2626 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6006955.38483 | 2121356.90745 | 37.8052342151411 | -122.420190167466 | (37.8052342151411, -122.420190167466) | 5 | 1 | 1 | 28858 | 32 | |||
112201 | 11159 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2627 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6006915.19061 | 2121341.6845 | 37.8051901519615 | -122.420328183697 | (37.8051901519615, -122.420328183697) | 5 | 1 | 1 | 28858 | 32 | |||
147850 | 65849 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 66 Rico Way | 1 | Front Yard : Yard | Tree | Private 2 | 12/19/2007 12:00:00 AM | 3x3 | Permit Number 50013 | 6001352.95008446 | 2121456.09779386 | 37.8051893002679 | -122.439585161616 | (37.8051893002679, -122.439585161616) | 13 | 9 | 1 | 57 | 17 | ||
126462 | 131966 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2618 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6006960.06643 | 2121331.19961 | 37.8051638917552 | -122.420172140533 | (37.8051638917552, -122.420172140533) | 5 | 1 | 1 | 28858 | 32 | |||
150559 | 11157 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2621 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X3 | 6006915.48876 | 2121316.55267 | 37.8051211631688 | -122.420325367033 | (37.8051211631688, -122.420325367033) | 5 | 1 | 1 | 28858 | 32 | |||
149142 | 96895 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 777 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3.5x6 | 5999259.60924 | 2121474.02363 | 37.8051191558782 | -122.44683068639 | (37.8051191558782, -122.44683068639) | 13 | 9 | 1 | 57 | 17 | |||
129045 | 11156 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2618 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6006962.61287 | 2121312.50549 | 37.8051127059477 | -122.420162000697 | (37.8051127059477, -122.420162000697) | 5 | 1 | 1 | 28858 | 32 | |||
32179 | 87737 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3200X Van Ness Ave | 9 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005484.434281 | 2121339.28256 | 37.8051028305372 | -122.4252793245 | (37.8051028305372, -122.4252793245) | 5 | 1 | 1 | 28858 | 32 | ||
62815 | 87731 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3200X Van Ness Ave | 3 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005484.434281 | 2121339.28256 | 37.8051028305372 | -122.4252793245 | (37.8051028305372, -122.4252793245) | 5 | 1 | 1 | 28858 | 32 | ||
74994 | 87736 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3200X Van Ness Ave | 8 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005484.434281 | 2121339.28256 | 37.8051028305372 | -122.4252793245 | (37.8051028305372, -122.4252793245) | 5 | 1 | 1 | 28858 | 32 | ||
140739 | 87734 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3200X Van Ness Ave | 6 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 4x4 | 6005484.434281 | 2121339.28256 | 37.8051028305372 | -122.4252793245 | (37.8051028305372, -122.4252793245) | 5 | 1 | 1 | 28858 | 32 | |||
86231 | 96896 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 777 Marina Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3.5x6 | 5999265.80771 | 2121460.84371 | 37.8050833214902 | -122.446808286977 | (37.8050833214902, -122.446808286977) | 13 | 9 | 1 | 57 | 17 | |||
34833 | 11155 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2615 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6006917.28019 | 2121296.80497 | 37.805067041968 | -122.420317765078 | (37.805067041968, -122.420317765078) | 5 | 1 | 1 | 28858 | 32 | |||
26318 | 11153 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2603 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6006916.69653 | 2121280.21725 | 37.8050214634311 | -122.420318606842 | (37.8050214634311, -122.420318606842) | 5 | 1 | 1 | 28858 | 32 | |||
103301 | 131864 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 801 Marina Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5999091.87418 | 2121434.80116 | 37.8050018779848 | -122.447408326338 | (37.8050018779848, -122.447408326338) | 13 | 9 | 1 | 57 | 17 | ||||
86152 | 131965 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2616 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6006966.56349 | 2121270.91846 | 37.8049987411622 | -122.420145375824 | (37.8049987411622, -122.420145375824) | 5 | 1 | 1 | 28858 | 32 | |||
133899 | 11154 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2603 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6006919.78752 | 2121256.32481 | 37.8049560350585 | -122.420306213261 | (37.8049560350585, -122.420306213261) | 5 | 1 | 1 | 28858 | 32 | |||
45231 | 131964 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2616 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6006972.36413 | 2121248.27564 | 37.8049368965806 | -122.420123694077 | (37.8049368965806, -122.420123694077) | 5 | 1 | 1 | 28858 | 32 | |||
108624 | 131800 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3646 Baker St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 5999162.81759 | 2121382.53624 | 37.8048624264288 | -122.447159055839 | (37.8048624264288, -122.447159055839) | 13 | 9 | 1 | 57 | 17 | |||
37560 | 1759 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2606X Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006953 | 2121208 | 37.8048252188779 | -122.42018784574 | (37.8048252188779, -122.42018784574) | 5 | 1 | 1 | 28858 | 32 | |||
93682 | 1757 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2606 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6006953 | 2121208 | 37.8048252188779 | -122.42018784574 | (37.8048252188779, -122.42018784574) | 5 | 1 | 1 | 28858 | 32 | |||
166019 | 1758 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2606 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6006953 | 2121208 | 37.8048252188779 | -122.42018784574 | (37.8048252188779, -122.42018784574) | 5 | 1 | 1 | 28858 | 32 | |||
106970 | 55910 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3646 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1973 12:00:00 AM | 7 | Permit Number 11968 | 5999164.92629 | 2121362.07154 | 37.8048063563971 | -122.447150284777 | (37.8048063563971, -122.447150284777) | 13 | 9 | 1 | 57 | 17 | ||
58517 | 41206 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3720 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1999 12:00:00 AM | 8 | Permit Number 41913 | 5999654.61261 | 2121348.57822 | 37.8047972741475 | -122.445454709292 | (37.8047972741475, -122.445454709292) | 13 | 9 | 1 | 57 | 17 | |
32349 | 88001 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 801 Bay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50823 | 6006952 | 2121180 | 37.8047482816685 | -122.420189317926 | (37.8047482816685, -122.420189317926) | 5 | 1 | 1 | 28858 | 32 | ||
46511 | 88000 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 801 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50823 | 6006952 | 2121180 | 37.8047482816685 | -122.420189317926 | (37.8047482816685, -122.420189317926) | 5 | 1 | 1 | 28858 | 32 | ||
97992 | 88002 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 801 Bay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50823 | 6006952 | 2121180 | 37.8047482816685 | -122.420189317926 | (37.8047482816685, -122.420189317926) | 5 | 1 | 1 | 28858 | 32 | ||
122355 | 87999 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 801 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50823 | 6006952 | 2121180 | 37.8047482816685 | -122.420189317926 | (37.8047482816685, -122.420189317926) | 5 | 1 | 1 | 28858 | 32 | ||
171589 | 87998 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 801 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50823 | 6006952 | 2121180 | 37.8047482816685 | -122.420189317926 | (37.8047482816685, -122.420189317926) | 5 | 1 | 1 | 28858 | 32 | ||
35922 | 11146 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2595X Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 40 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.8047412018915 | -122.420255726238 | (37.8047412018915, -122.420255726238) | 5 | 1 | 1 | 28858 | 32 | |||
102742 | 11150 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2595X Hyde St | 6 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.8047412018915 | -122.420255726238 | (37.8047412018915, -122.420255726238) | 5 | 1 | 1 | 28858 | 32 | |||
111891 | 11145 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2595X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.8047412018915 | -122.420255726238 | (37.8047412018915, -122.420255726238) | 5 | 1 | 1 | 28858 | 32 | |||
112297 | 11148 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2595X Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 40 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.8047412018915 | -122.420255726238 | (37.8047412018915, -122.420255726238) | 5 | 1 | 1 | 28858 | 32 | |||
139815 | 11152 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2595X Hyde St | 8 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.8047412018915 | -122.420255726238 | (37.8047412018915, -122.420255726238) | 5 | 1 | 1 | 28858 | 32 | |||
156707 | 11149 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2595X Hyde St | 5 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.8047412018915 | -122.420255726238 | (37.8047412018915, -122.420255726238) | 5 | 1 | 1 | 28858 | 32 | |||
161832 | 11151 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2595X Hyde St | 7 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.8047412018915 | -122.420255726238 | (37.8047412018915, -122.420255726238) | 5 | 1 | 1 | 28858 | 32 | |||
187882 | 11147 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2595X Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.8047412018915 | -122.420255726238 | (37.8047412018915, -122.420255726238) | 5 | 1 | 1 | 28858 | 32 | |||
27819 | 131863 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3640 Lyon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5998876.58216 | 2121318.22377 | 37.8046694831589 | -122.448144966435 | (37.8046694831589, -122.448144966435) | 13 | 9 | 1 | 57 | 17 | |||
87342 | 11143 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2553X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 36 | 3X3 | 6006932.12852 | 2121148.49105 | 37.804660646435 | -122.420255847653 | (37.804660646435, -122.420255847653) | 5 | 1 | 1 | 28858 | 32 | |||
153965 | 131971 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 851 Bay St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006836.95388 | 2121150.13157 | 37.8046597875834 | -122.420585325955 | (37.8046597875834, -122.420585325955) | 5 | 1 | 1 | 28858 | 32 | |||
133499 | 131862 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3640 Lyon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 7ft | 5998877.1278 | 2121309.5311 | 37.8046456466411 | -122.448142451907 | (37.8046456466411, -122.448142451907) | 13 | 9 | 1 | 57 | 17 | |||
133664 | 27383 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2560 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 3X3 | 6006988.37342 | 2121139.78035 | 37.8046398981635 | -122.420060587734 | (37.8046398981635, -122.420060587734) | 5 | 1 | 1 | 28858 | 32 | |||
175494 | 131970 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 851 Bay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006761.3651 | 2121137.86846 | 37.8046218559624 | -122.420846037638 | (37.8046218559624, -122.420846037638) | 5 | 1 | 1 | 28858 | 32 | |||
43055 | 131861 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3640 Lyon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 9ft | 5998876.90196 | 2121298.68391 | 37.8046158502946 | -122.448142451919 | (37.8046158502946, -122.448142451919) | 13 | 9 | 1 | 57 | 17 | |||
154418 | 11144 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2553X Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 36 | 3X3 | 6006934.8566 | 2121129.59308 | 37.8046089111446 | -122.420245064768 | (37.8046089111446, -122.420245064768) | 5 | 1 | 1 | 28858 | 32 | |||
138795 | 131799 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3622 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999175.50089 | 2121283.38035 | 37.8045908959147 | -122.447108023813 | (37.8045908959147, -122.447108023813) | 13 | 9 | 1 | 57 | 17 | |||
47475 | 131969 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 851 Bay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006677.69504 | 2121126.15503 | 37.8045849774818 | -122.421134754189 | (37.8045849774818, -122.421134754189) | 5 | 1 | 1 | 28858 | 32 | |||
103223 | 131977 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2553 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6006939.66752 | 2121114.42816 | 37.804567543218 | -122.420227339129 | (37.804567543218, -122.420227339129) | 5 | 1 | 1 | 28858 | 32 | |||
36974 | 131978 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2553 Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6006942.77558 | 2121093.18937 | 37.8045094020391 | -122.420215075084 | (37.8045094020391, -122.420215075084) | 5 | 1 | 1 | 28858 | 32 | |||
48925 | 131979 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2553 Hyde St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006943.6735 | 2121075.27291 | 37.8044602585979 | -122.420210695394 | (37.8044602585979, -122.420210695394) | 5 | 1 | 1 | 28858 | 32 | |||
150727 | 131980 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2553 Hyde St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006950.58761 | 2121054.46009 | 37.804403501475 | -122.420185290441 | (37.804403501475, -122.420185290441) | 5 | 1 | 1 | 28858 | 32 | |||
174187 | 103501 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2050 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768855 | 5999398.93831 | 2121201.05628 | 37.8043776199 | -122.446328874603 | (37.8043776199, -122.446328874603) | 13 | 9 | 1 | 57 | 17 | |
72118 | 131847 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3601 Baker St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 3ft | 5999134.00853 | 2121203.20674 | 37.8043683901552 | -122.447245837734 | (37.8043683901552, -122.447245837734) | 13 | 9 | 1 | 57 | 17 | |||
151248 | 131849 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3601 Baker St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 2ft | 5999142.98862 | 2121202.59701 | 37.8043672291134 | -122.447214717591 | (37.8043672291134, -122.447214717591) | 13 | 9 | 1 | 57 | 17 | |||
49599 | 131860 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2050 Jefferson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999372.26624 | 2121195.48978 | 37.8043608124563 | -122.446420774504 | (37.8043608124563, -122.446420774504) | 13 | 9 | 1 | 57 | 17 | |||
179189 | 34243 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 281 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/1999 12:00:00 AM | 6 | Permit Number 41308 | 6010484.3701 | 2120961.6992 | 37.8043472811285 | -122.407949730391 | (37.8043472811285, -122.407949730391) | 3 | 1 | 10 | 308 | 23 | ||
160306 | 131981 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2553 Hyde St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6006953.1951 | 2121033.48378 | 37.8043460527886 | -122.420174777362 | (37.8043460527886, -122.420174777362) | 5 | 1 | 1 | 28858 | 32 | |||
175795 | 131850 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3601 Baker St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 2ft | 5999143.57978 | 2121190.63067 | 37.8043344065648 | -122.447211810097 | (37.8043344065648, -122.447211810097) | 13 | 9 | 1 | 57 | 17 |
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) );