trees
7,157 rows where qSpecies_id = 36 sorted by PlotSize 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40851 | 194655 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 637 Carolina St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 9ft | 6012415.84773 | 2104999.11852 | 37.7606256859357 | -122.400143902236 | (37.7606256859357, -122.400143902236) | 10 | 3 | 8 | 28856 | 29 | |||
64265 | 194781 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 37 Maddux Ave | 2 | Front Yard : Yard | Tree | Private 2 | 9 | Width 9ft | 6012782.01516 | 2095526.39332 | 37.734636019838 | -122.398212872552 | (37.734636019838, -122.398212872552) | 10 | 3 | 8 | 58 | 1 | |||
64545 | 194633 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 500 Wisconsin St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 9ft | 6012635.5698 | 2105111.4439 | 37.7609463553975 | -122.399391863957 | (37.7609463553975, -122.399391863957) | 10 | 3 | 8 | 28856 | 29 | |||
79396 | 132679 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 16 Heather Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 9ft | 5997380.73258 | 2114357.4428 | 37.7854714324112 | -122.452818754791 | (37.7854714324112, -122.452818754791) | 15 | 6 | 1 | 54 | 31 | |||
84985 | 132675 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Heather Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 9ft | 5997331.41397 | 2114381.51283 | 37.7855346961081 | -122.452991119752 | (37.7855346961081, -122.452991119752) | 15 | 6 | 1 | 54 | 31 | |||
2946 | 211579 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 80 San Fernando Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 8ft | 5992099.63663 | 2096102.89356 | 37.7350452131685 | -122.469760152011 | (37.7350452131685, -122.469760152011) | 1 | 8 | 4 | 59 | 40 | |||
5927 | 211582 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 77 San Fernando Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 8ft | 5992130.49269 | 2096095.02259 | 37.7350253849109 | -122.469652899757 | (37.7350253849109, -122.469652899757) | 1 | 8 | 4 | 59 | 40 | |||
14520 | 194759 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 901 Phelps St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6014822.60831 | 2097331.18487 | 37.7397050602466 | -122.391283914518 | (37.7397050602466, -122.391283914518) | 10 | 3 | 8 | 58 | 1 | |||
14647 | 211590 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 35 San Fernando Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 8ft | 5992122.71574 | 2096357.16158 | 37.7357447031529 | -122.469698865033 | (37.7357447031529, -122.469698865033) | 1 | 8 | 4 | 59 | 40 | |||
16593 | 133150 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 240 Vallejo St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 8ft | 6012279.1399 | 2119168.16848 | 37.7995229994372 | -122.401612607536 | (37.7995229994372, -122.401612607536) | 3 | 1 | 10 | 28860 | 6 | |||
18125 | 211591 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 35 San Fernando Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 8ft | 5992120.623 | 2096391.70726 | 37.7358394359365 | -122.469708614571 | (37.7358394359365, -122.469708614571) | 1 | 8 | 4 | 59 | 40 | |||
20617 | 211574 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 38 San Fernando Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 8ft | 5992093.17139 | 2096255.07977 | 37.7354627045261 | -122.469793580725 | (37.7354627045261, -122.469793580725) | 1 | 8 | 4 | 59 | 40 | |||
31242 | 211575 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 66 San Fernando Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 8ft | 5992095.01357 | 2096227.76015 | 37.7353877982039 | -122.46978522332 | (37.7353877982039, -122.46978522332) | 1 | 8 | 4 | 59 | 40 | |||
35809 | 133192 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1306x Montgomery St | 41 | Median : Yard | Tree | DPW 1 | 2 | Width 8ft | 6011420.83782 | 2120184.50099 | 37.8022656699768 | -122.404654242423 | (37.8022656699768, -122.404654242423) | 3 | 1 | 10 | 308 | 23 | |||
36152 | 119936 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 6500x Geary Blvd | 7 | Median : Yard | Tree | DPW 1 | 1 | Width 8ft | 5986709.57611 | 2112539.19718 | 37.7798617820891 | -122.489603541423 | (37.7798617820891, -122.489603541423) | 11 | 6 | 2 | 55 | 26 | |||
36950 | 211592 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 San Fernando Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 8ft | 5992116.4659 | 2096423.88969 | 37.7359275605095 | -122.469725329388 | (37.7359275605095, -122.469725329388) | 1 | 8 | 4 | 59 | 40 | |||
37070 | 133147 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 240 Vallejo St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6012329.88439 | 2119185.49639 | 37.7995734091372 | -122.401438230791 | (37.7995734091372, -122.401438230791) | 3 | 1 | 10 | 28860 | 6 | |||
38702 | 211580 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 80 San Fernando Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 8ft | 5992099.7077 | 2096067.98855 | 37.7349493768937 | -122.469757365921 | (37.7349493768937, -122.469757365921) | 1 | 8 | 4 | 59 | 40 | |||
43039 | 211588 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 45 San Fernando Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 8ft | 5992125.93588 | 2096280.46722 | 37.7355343058589 | -122.469682150222 | (37.7355343058589, -122.469682150222) | 1 | 8 | 4 | 59 | 40 | |||
43612 | 235070 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 215 Downey St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 21 | Width 8ft | 5998946.73151 | 2106903.42094 | 37.7650942121447 | -122.446864321949 | (37.7650942121447, -122.446864321949) | 15 | 5 | 11 | 29492 | 9 | |||
49915 | 211581 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 77 San Fernando Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 8ft | 5992131.98308 | 2096070.11741 | 37.7349570876863 | -122.469645934506 | (37.7349570876863, -122.469645934506) | 1 | 8 | 4 | 59 | 40 | |||
50437 | 211569 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 San Fernando Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 8ft | 5992086.69508 | 2096387.6074 | 37.7358262176954 | -122.469825617276 | (37.7358262176954, -122.469825617276) | 1 | 8 | 4 | 59 | 40 | |||
68372 | 211573 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 38 San Fernando Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 8ft | 5992093.28359 | 2096279.54966 | 37.7355298991718 | -122.469794973768 | (37.7355298991718, -122.469794973768) | 1 | 8 | 4 | 59 | 40 | |||
80952 | 194654 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 645 Carolina St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012425.54956 | 2104933.19465 | 37.7604452145047 | -122.400105717907 | (37.7604452145047, -122.400105717907) | 10 | 3 | 8 | 28856 | 29 | |||
87657 | 235071 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 229 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 8ft | 5998960.19711 | 2106819.62555 | 37.7648649003197 | -122.446811717909 | (37.7648649003197, -122.446811717909) | 15 | 5 | 11 | 29492 | 9 | |||
96322 | 211572 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 38 San Fernando Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 8ft | 5992093.98426 | 2096312.83351 | 37.7356213287469 | -122.46979497376 | (37.7356213287469, -122.46979497376) | 1 | 8 | 4 | 59 | 40 | |||
99667 | 133175 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1900 The Embarcadero | 11 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 8ft | 6010562.9606 | 2122079.77861 | 37.8074216496552 | -122.407756646259 | (37.8074216496552, -122.407756646259) | 3 | 1 | 10 | 308 | 23 | |||
101437 | 194644 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 572 Wisconsin St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6012645.84316 | 2104862.85843 | 37.760264367115 | -122.399338881302 | (37.760264367115, -122.399338881302) | 10 | 3 | 8 | 28856 | 29 | |||
105496 | 211860 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 209 Edna St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 5998729.95936 | 2093573.74387 | 37.7284817710917 | -122.446654939085 | (37.7284817710917, -122.446654939085) | 9 | 7 | 4 | 28861 | 40 | |||
123883 | 211584 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 75 San Fernando Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 8ft | 5992129.81291 | 2096158.4246 | 37.7351994316028 | -122.46965986413 | (37.7351994316028, -122.46965986413) | 1 | 8 | 4 | 59 | 40 | |||
127270 | 211587 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 55 San Fernando Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 8ft | 5992126.7727 | 2096262.79724 | 37.7354858369058 | -122.46967797107 | (37.7354858369058, -122.46967797107) | 1 | 8 | 4 | 59 | 40 | |||
130026 | 211577 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 66 San Fernando Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 8ft | 5992095.34116 | 2096166.77291 | 37.7352203615189 | -122.469779652023 | (37.7352203615189, -122.469779652023) | 1 | 8 | 4 | 59 | 40 | |||
130387 | 211593 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 San Fernando Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 8ft | 5992107.01458 | 2096453.37497 | 37.7360079733772 | -122.469760152022 | (37.7360079733772, -122.469760152022) | 1 | 8 | 4 | 59 | 40 | |||
138679 | 211570 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 San Fernando Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 8ft | 5992088.91212 | 2096368.18587 | 37.7357730192142 | -122.469816538616 | (37.7357730192142, -122.469816538616) | 1 | 8 | 4 | 59 | 40 | |||
143439 | 247895 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 350 Mayflower St | 1 | Front Yard : Yard | Tree | Private 2 | 8 | Width 8ft | 6010134.20448 | 2098367.81195 | 37.7422901021203 | -122.407567559293 | (37.7422901021203, -122.407567559293) | 10 | 7 | 7 | 28859 | 2 | |||
161191 | 211571 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 San Fernando Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 8ft | 5992089.09767 | 2096348.64202 | 37.7357193674478 | -122.469814474651 | (37.7357193674478, -122.469814474651) | 1 | 8 | 4 | 59 | 40 | |||
163188 | 211585 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 65 San Fernando Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 8ft | 5992128.63755 | 2096217.42387 | 37.7353613608291 | -122.469668221507 | (37.7353613608291, -122.469668221507) | 1 | 8 | 4 | 59 | 40 | |||
165207 | 211583 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 75 San Fernando Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 8ft | 5992130.37962 | 2096127.92234 | 37.7351157128196 | -122.469655684988 | (37.7351157128196, -122.469655684988) | 1 | 8 | 4 | 59 | 40 | |||
171509 | 211576 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 66 San Fernando Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 8ft | 5992095.52933 | 2096194.85192 | 37.7352974702943 | -122.469781045069 | (37.7352974702943, -122.469781045069) | 1 | 8 | 4 | 59 | 40 | |||
172689 | 211586 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 55 San Fernando Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 8ft | 5992128.07711 | 2096229.07028 | 37.7353933065496 | -122.469671006727 | (37.7353933065496, -122.469671006727) | 1 | 8 | 4 | 59 | 40 | |||
174283 | 211589 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 35 San Fernando Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 8ft | 5992124.08766 | 2096326.64236 | 37.7356609843507 | -122.469691900687 | (37.7356609843507, -122.469691900687) | 1 | 8 | 4 | 59 | 40 | |||
183306 | 211578 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 80 San Fernando Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 8ft | 5992098.25627 | 2096133.01172 | 37.7351278302775 | -122.469767116367 | (37.7351278302775, -122.469767116367) | 1 | 8 | 4 | 59 | 40 | |||
185475 | 194653 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 645 Carolina St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6012425.61967 | 2104924.82813 | 37.7604222457984 | -122.400104887842 | (37.7604222457984, -122.400104887842) | 10 | 3 | 8 | 28856 | 29 | |||
191859 | 180628 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 339 Cordova St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 11:40:00 AM | 3 | Width 8ft | 6001976.18123 | 2086917.49182 | 37.7103900879138 | -122.434956757573 | (37.7103900879138, -122.434956757573) | 9 | 7 | 6 | 28861 | 5 | ||
1034 | 194657 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1701 19th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 7ft | 6012465.19562 | 2105138.61132 | 37.7610114537331 | -122.39998302521 | (37.7610114537331, -122.39998302521) | 10 | 3 | 8 | 28856 | 29 | |||
44156 | 194660 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1701 19th St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 7ft | 6012576.32425 | 2105145.45515 | 37.7610364405081 | -122.399599157683 | (37.7610364405081, -122.399599157683) | 10 | 3 | 8 | 28856 | 29 | |||
46743 | 124391 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3950 Sacramento St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 7ft | 5995978.19711 | 2114903.66363 | 37.7868907390191 | -122.457710618848 | (37.7868907390191, -122.457710618848) | 11 | 6 | 1 | 54 | 31 | |||
155879 | 249717 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2500 Broderick St | 1 | Front Yard : Yard | Tree | Private 2 | 9 | Width 7ft | 6000147.51069 | 2117427.00959 | 37.79405781668 | -122.443467123026 | (37.79405781668, -122.443467123026) | 13 | 9 | 1 | 57 | 27 | |||
176184 | 194658 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1701 19th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 7ft | 6012479.13333 | 2105137.66671 | 37.7610096371024 | -122.399934754094 | (37.7610096371024, -122.399934754094) | 10 | 3 | 8 | 28856 | 29 | |||
467 | 211626 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 299x Magellan Ave | 6 | Median : Cutout | Tree | DPW 1 | 6 | Width 6ft | 5994442.33797 | 2100102.58449 | 37.7461624991943 | -122.461950600334 | (37.7461624991943, -122.461950600334) | 1 | 8 | 4 | 29491 | 40 | |||
4909 | 194805 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 503 Beale St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6015913.1436 | 2114020.02003 | 37.7855894765281 | -122.388677968825 | (37.7855894765281, -122.388677968825) | 6 | 2 | 9 | 28856 | 6 | |||
8737 | 180668 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 360 Chicago Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 01:45:00 PM | 3 | Width 6ft | 6002314.90905 | 2086461.72548 | 37.709157880008 | -122.433753490754 | (37.709157880008, -122.433753490754) | 9 | 7 | 6 | 28861 | 5 | ||
10987 | 211628 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 299x Magellan Ave | 8 | Median : Cutout | Tree | DPW 1 | 14 | Width 6ft | 5994455.12768 | 2100116.98357 | 37.7462027717556 | -122.461907419396 | (37.7462027717556, -122.461907419396) | 1 | 8 | 4 | 29491 | 40 | |||
11162 | 194818 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 502 Beale St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6015745.50684 | 2114096.95158 | 37.785791421082 | -122.389263322262 | (37.785791421082, -122.389263322262) | 6 | 2 | 9 | 28856 | 6 | |||
12251 | 180667 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 344 Chicago Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 01:51:00 PM | 3 | Width 6ft | 6002403.88387 | 2086502.6359 | 37.7092752595273 | -122.43344890204 | (37.7092752595273, -122.43344890204) | 9 | 7 | 6 | 28861 | 5 | ||
18294 | 194832 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 541 Delancey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 6ft | 6015383.05576 | 2113537.08533 | 37.7842340552103 | -122.390478177732 | (37.7842340552103, -122.390478177732) | 6 | 2 | 9 | 28856 | 6 | |||
19236 | 211560 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 155 San Fernando Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 6ft | 5992149.38652 | 2095672.12891 | 37.7338653170184 | -122.469556802705 | (37.7338653170184, -122.469556802705) | 9 | 8 | 4 | 59 | 40 | |||
22538 | 194837 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 541 Delancey St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6015273.81203 | 2113648.91518 | 37.784535053803 | -122.390863943721 | (37.784535053803, -122.390863943721) | 6 | 2 | 9 | 28856 | 6 | |||
22877 | 194827 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 543 Delancey St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6015502.02517 | 2113413.42728 | 37.7839011171861 | -122.390057940738 | (37.7839011171861, -122.390057940738) | 6 | 2 | 9 | 28856 | 6 | |||
26367 | 211552 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100 San Fernando Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 6ft | 5992136.87405 | 2095942.37241 | 37.7346066146902 | -122.469619728264 | (37.7346066146902, -122.469619728264) | 9 | 8 | 4 | 59 | 40 | |||
27744 | 194830 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 543 Delancey St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6015461.92015 | 2113453.78757 | 37.7840097130328 | -122.390199511114 | (37.7840097130328, -122.390199511114) | 6 | 2 | 9 | 28856 | 6 | |||
28019 | 211611 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 120 Santa Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5994051.46407 | 2097166.70341 | 37.738078794604 | -122.46308920142 | (37.738078794604, -122.46308920142) | 9 | 8 | 4 | 59 | 40 | |||
28212 | 211625 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 299x Magellan Ave | 5 | Median : Cutout | Tree | DPW 1 | 9 | Width 6ft | 5994395.62739 | 2100058.6055 | 37.7460390546617 | -122.462108929608 | (37.7460390546617, -122.462108929608) | 1 | 8 | 4 | 29491 | 40 | |||
28351 | 132489 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2420 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 6ft | 6001396.24797 | 2118356.68507 | 37.7966815968199 | -122.439213037457 | (37.7966815968199, -122.439213037457) | 13 | 9 | 1 | 57 | 17 | |||
29949 | 194816 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 502 Beale St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6015723.9379 | 2114119.71149 | 37.7858527188632 | -122.389339535303 | (37.7858527188632, -122.389339535303) | 6 | 2 | 9 | 28856 | 6 | |||
31271 | 211621 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 299x Magellan Ave | 1 | Median : Cutout | Tree | DPW 1 | 13 | Width 6ft | 5994368.11435 | 2100029.21026 | 37.7459567586067 | -122.46220193388 | (37.7459567586067, -122.46220193388) | 1 | 8 | 4 | 29491 | 40 | |||
31835 | 194825 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 502 Beale St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6015880.685 | 2113956.19903 | 37.785412439566 | -122.388785810138 | (37.785412439566, -122.388785810138) | 6 | 2 | 9 | 28856 | 6 | |||
33031 | 194821 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 502 Beale St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6015838.92258 | 2114002.27356 | 37.785536635052 | -122.388933514791 | (37.785536635052, -122.388933514791) | 6 | 2 | 9 | 28856 | 6 | |||
34615 | 211623 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 299x Magellan Ave | 3 | Median : Cutout | Tree | DPW 1 | 4 | Width 6ft | 5994380.19726 | 2100040.43559 | 37.7459882762472 | -122.462160967071 | (37.7459882762472, -122.462160967071) | 1 | 8 | 4 | 29491 | 40 | |||
35681 | 120030 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 5250 Fulton St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5987030.11387 | 2109846.23506 | 37.7724863769702 | -122.488296717273 | (37.7724863769702, -122.488296717273) | 11 | 6 | 2 | 55 | 26 | |||
40973 | 211562 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 165 San Fernando Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 6ft | 5992149.97885 | 2095610.19054 | 37.7336952840165 | -122.469550247546 | (37.7336952840165, -122.469550247546) | 9 | 8 | 4 | 59 | 40 | |||
41292 | 132609 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 300 Laurel St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 5998078.63755 | 2115348.43003 | 37.788232388848 | -122.450475688113 | (37.788232388848, -122.450475688113) | 11 | 6 | 1 | 54 | 31 | |||
44773 | 132607 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 300 Laurel St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 5998069.1356 | 2115417.33363 | 37.7884210360372 | -122.450513532469 | (37.7884210360372, -122.450513532469) | 11 | 6 | 1 | 54 | 31 | |||
46523 | 178507 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 40 Baltimore Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6003050.64825 | 2086672.71394 | 37.7097789302122 | -122.431225715016 | (37.7097789302122, -122.431225715016) | 9 | 7 | 6 | 28861 | 5 | |||
47925 | 211629 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 299x Magellan Ave | 9 | Median : Cutout | Tree | DPW 1 | 7 | Width 6ft | 5994463.26259 | 2100123.19006 | 37.7462202815386 | -122.461879740062 | (37.7462202815386, -122.461879740062) | 1 | 8 | 4 | 29491 | 40 | |||
48246 | 211553 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100 San Fernando Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5992139.83794 | 2095903.04051 | 37.7344987904706 | -122.469606618863 | (37.7344987904706, -122.469606618863) | 9 | 8 | 4 | 59 | 40 | |||
50871 | 194828 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 543 Delancey St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6015490.7383 | 2113424.95536 | 37.7839321446898 | -122.390097795086 | (37.7839321446898, -122.390097795086) | 6 | 2 | 9 | 28856 | 6 | |||
52071 | 194809 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 503 Beale St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6015859.99532 | 2114071.17734 | 37.7857269972351 | -122.388865420803 | (37.7857269972351, -122.388865420803) | 6 | 2 | 9 | 28856 | 6 | |||
54801 | 194819 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 502 Beale St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6015759.00914 | 2114080.17835 | 37.7857461141309 | -122.389215436053 | (37.7857461141309, -122.389215436053) | 6 | 2 | 9 | 28856 | 6 | |||
58655 | 211607 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 150 Santa Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 6ft | 5994146.19508 | 2097273.42377 | 37.7383772786889 | -122.462769411474 | (37.7383772786889, -122.462769411474) | 9 | 8 | 4 | 59 | 40 | |||
59007 | 194826 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 543 Delancey St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 6ft | 6015513.30488 | 2113401.55708 | 37.7838691498875 | -122.390018087287 | (37.7838691498875, -122.390018087287) | 6 | 2 | 9 | 28856 | 6 | |||
60540 | 194810 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 503 Beale St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6015847.99108 | 2114086.03666 | 37.7857671321996 | -122.388907990207 | (37.7857671321996, -122.388907990207) | 6 | 2 | 9 | 28856 | 6 | |||
61837 | 194635 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 500 Wisconsin St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 6ft | 6012639.96603 | 2105085.05344 | 37.7608741380455 | -122.399374806508 | (37.7608741380455, -122.399374806508) | 10 | 3 | 8 | 28856 | 29 | |||
64278 | 211610 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 130 Santa Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 5994066.89971 | 2097182.67005 | 37.7381235241814 | -122.463036991265 | (37.7381235241814, -122.463036991265) | 9 | 8 | 4 | 59 | 40 | |||
66496 | 211557 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 135 San Fernando Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 6ft | 5992141.43314 | 2095780.66634 | 37.7341628739104 | -122.469592198229 | (37.7341628739104, -122.469592198229) | 9 | 8 | 4 | 59 | 40 | |||
67338 | 194807 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 503 Beale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6015887.13283 | 2114046.76968 | 37.7856614834305 | -122.388769827389 | (37.7856614834305, -122.388769827389) | 6 | 2 | 9 | 28856 | 6 | |||
67876 | 211608 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 140 Santa Monica Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5994113.27928 | 2097234.01447 | 37.738267174698 | -122.462880359062 | (37.738267174698, -122.462880359062) | 9 | 8 | 4 | 59 | 40 | |||
71109 | 194814 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 502 Beale St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6015698.88503 | 2114143.70647 | 37.7859172146572 | -122.389427888293 | (37.7859172146572, -122.389427888293) | 6 | 2 | 9 | 28856 | 6 | |||
71799 | 132573 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3800 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 5996509.23415 | 2115630.608 | 37.7889172252977 | -122.455925935843 | (37.7889172252977, -122.455925935843) | 11 | 6 | 1 | 54 | 31 | |||
73003 | 194764 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1101 Newhall St | 1 | : | Tree | Private 2 | 1 | Width 6ft | 6014997.18752 | 2096468.24359 | 37.7373452877474 | -122.390620003515 | (37.7373452877474, -122.390620003515) | 10 | 3 | 8 | 58 | 1 | |||
73132 | 133133 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 855 Chestnut St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6007791.37883 | 2120586.43347 | 37.8031657573499 | -122.417242466784 | (37.8031657573499, -122.417242466784) | 5 | 1 | 1 | 308 | 32 | |||
74688 | 194835 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 541 Delancey St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6015344.03022 | 2113580.43497 | 37.7843509185101 | -122.390616223664 | (37.7843509185101, -122.390616223664) | 6 | 2 | 9 | 28856 | 6 | |||
75338 | 122993 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 128 07th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 6ft | 5993679.3861 | 2114627.96128 | 37.7860014089293 | -122.465643873807 | (37.7860014089293, -122.465643873807) | 11 | 6 | 2 | 54 | 11 | |||
76002 | 132606 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 Laurel St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 6ft | 5998067.82887 | 2115435.37525 | 37.7884704987534 | -122.450519354702 | (37.7884704987534, -122.450519354702) | 11 | 6 | 1 | 54 | 31 | |||
78853 | 211561 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 155 San Fernando Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 6ft | 5992149.62806 | 2095647.58018 | 37.7337979263208 | -122.469554181198 | (37.7337979263208, -122.469554181198) | 9 | 8 | 4 | 59 | 40 | |||
78910 | 234036 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 143 Scott St | 1 | : | Tree | Private 2 | 8 | Width 6ft | 6002306.01138 | 2109052.49296 | 37.7711863734766 | -122.435399155653 | (37.7711863734766, -122.435399155653) | 15 | 5 | 11 | 29492 | 9 | |||
83439 | 194824 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 502 Beale St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6015871.5156 | 2113965.50811 | 37.785437491981 | -122.388818183917 | (37.785437491981, -122.388818183917) | 6 | 2 | 9 | 28856 | 6 | |||
85227 | 234272 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 217 Montcalm St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 6ft | 6009881.38473 | 2099607.36968 | 37.7456795021103 | -122.40852915582 | (37.7456795021103, -122.40852915582) | 2 | 7 | 7 | 28859 | 2 | |||
85345 | 211604 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 150 Santa Monica Way | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5994181.35128 | 2097314.6655 | 37.7384925429997 | -122.462650850283 | (37.7384925429997, -122.462650850283) | 9 | 8 | 4 | 59 | 40 | |||
92363 | 194806 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 503 Beale St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6015898.48961 | 2114031.92346 | 37.785621348501 | -122.388729499078 | (37.785621348501, -122.388729499078) | 6 | 2 | 9 | 28856 | 6 |
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) );