trees
7,157 rows where qSpecies_id = 36 sorted by Supervisor Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
448 | 17338 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 175X Otis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/18/1993 12:00:00 AM | 12 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.420111956743 | (37.7705111956623, -122.420111956743) | 8 | 2 | 9 | 28853 | 19 | ||
535 | 50166 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 159 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/11/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46878 | 6010492.5895 | 2111415.08321 | 37.7781350293519 | -122.407247904281 | (37.7781350293519, -122.407247904281) | 14 | 2 | 9 | 28853 | 34 | |
634 | 79736 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 705 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6008945.3206 | 2110776.64932 | 37.7762953249107 | -122.412555345054 | (37.7762953249107, -122.412555345054) | 8 | 2 | 9 | 28853 | 34 | |||
2341 | 50690 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 5 | Permit Number 47259 | 6015829.14658 | 2115263.74647 | 37.7889998109335 | -122.389055445747 | (37.7889998109335, -122.389055445747) | 6 | 2 | 9 | 28855 | 6 | |
2651 | 116177 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 94X Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 2x2 | 6013088.14132 | 2114773.98934 | 37.7875027311189 | -122.3985046459 | (37.7875027311189, -122.3985046459) | 12 | 2 | 9 | 28855 | 6 | |||
2804 | 115921 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 50 Beale St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777610 | 6013791.45387 | 2116146.74475 | 37.7913111540478 | -122.396167553395 | (37.7913111540478, -122.396167553395) | 12 | 2 | 9 | 28855 | 6 | |
4144 | 194961 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 380 Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6011578.05189 | 2112446.27024 | 37.7810271186418 | -122.403565445814 | (37.7810271186418, -122.403565445814) | 6 | 2 | 9 | 28853 | 34 | |||
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 | |||
5350 | 50689 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 6 | Permit Number 47259 | 6015816.80871 | 2115251.31458 | 37.7889649918797 | -122.389097265149 | (37.7889649918797, -122.389097265149) | 6 | 2 | 9 | 28855 | 6 | |
5913 | 194980 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 705 Natoma St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6009005.03299 | 2110836.03944 | 37.7764617471498 | -122.412352981411 | (37.7764617471498, -122.412352981411) | 8 | 2 | 9 | 28853 | 34 | |||
7175 | 194622 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 131 Shipley St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6012020.07516 | 2112244.72696 | 37.780498408125 | -122.402022085964 | (37.780498408125, -122.402022085964) | 6 | 2 | 9 | 28856 | 34 | |||
7269 | 72440 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 409 Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6012482 | 2109734 | 37.7736302975223 | -122.400247669168 | (37.7736302975223, -122.400247669168) | 14 | 2 | 9 | 28853 | 34 | ||
7728 | 116230 | Section 806 (d) 5 | Pittosporum undulatum :: Victorian Box 36 | 49 Grace St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/2014 12:00:00 AM | 3 | 2.5x4 | Permit Number 770598 | 6008318.16403 | 2110322.45497 | 37.7750129977898 | -122.414692709823 | (37.7750129977898, -122.414692709823) | 8 | 2 | 9 | 28853 | 34 | |
7820 | 194790 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 30 Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6013605.05122 | 2116340.26995 | 37.7918321555771 | -122.396826080181 | (37.7918321555771, -122.396826080181) | 12 | 2 | 9 | 28855 | 6 | |||
7943 | 194966 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 380 Clementina St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6011517.79907 | 2112391.01147 | 37.7808720251553 | -122.403770001992 | (37.7808720251553, -122.403770001992) | 6 | 2 | 9 | 28853 | 34 | |||
8322 | 50693 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 3 | Permit Number 47259 | 6015899.29772 | 2115328.09963 | 37.7891803984034 | -122.388817224359 | (37.7891803984034, -122.388817224359) | 6 | 2 | 9 | 28855 | 6 | |
8401 | 28903 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 300 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | 3x3 | 6011671.18393 | 2112073.93673 | 37.7800099791183 | -122.403217054727 | (37.7800099791183, -122.403217054727) | 14 | 2 | 9 | 28856 | 34 | ||
8706 | 50165 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 175 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/2003 12:00:00 AM | 5 | 3x3 | Permit Number 47119 | 6010544.92166501 | 2111364.78189969 | 37.7779998423871 | -122.40706332103 | (37.7779998423871, -122.40706332103) | 14 | 2 | 9 | 28853 | 34 | |
10530 | 50696 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 4 | Permit Number 47259 | 6015925.73831 | 2115354.86226 | 37.7892553479159 | -122.388727611399 | (37.7892553479159, -122.388727611399) | 6 | 2 | 9 | 28855 | 6 | |
10726 | 113513 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 352 TURK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008306 | 2113136 | 37.7827376375446 | -122.414933965724 | (37.7827376375446, -122.414933965724) | 7 | 10 | 9 | 28852 | 36 | ||||
10738 | 50688 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 4 | Permit Number 47259 | 6015806.91345 | 2115242.27212 | 37.7889396148166 | -122.389130870094 | (37.7889396148166, -122.389130870094) | 6 | 2 | 9 | 28855 | 6 | |
10763 | 194618 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 131 Shipley St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012064.61514 | 2112283.75478 | 37.780608055269 | -122.401870744457 | (37.780608055269, -122.401870744457) | 6 | 2 | 9 | 28856 | 34 | |||
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 | |||
11278 | 194611 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 131 Shipley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6012143.7658 | 2112366.54969 | 37.7808398078518 | -122.401602743794 | (37.7808398078518, -122.401602743794) | 6 | 2 | 9 | 28856 | 34 | |||
11364 | 50692 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2004 12:00:00 AM | 4 | 4x4 | Permit Number 47259 | 6015887.62882 | 2115316.72883 | 37.7891485300247 | -122.388856803509 | (37.7891485300247, -122.388856803509) | 6 | 2 | 9 | 28855 | 6 | |
11527 | 50695 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 4 | Permit Number 47259 | 6015937.15224 | 2115364.30383 | 37.7892819048945 | -122.388688779581 | (37.7892819048945, -122.388688779581) | 6 | 2 | 9 | 28855 | 6 | |
12182 | 50691 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 5 | Permit Number 47259 | 6015877.9319 | 2115306.82257 | 37.7891207922267 | -122.388889662052 | (37.7891207922267, -122.388889662052) | 6 | 2 | 9 | 28855 | 6 | |
12585 | 50687 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 5 | Permit Number 47259 | 6015799.79693 | 2115231.88408 | 37.7889106971282 | -122.389154766877 | (37.7889106971282, -122.389154766877) | 6 | 2 | 9 | 28855 | 6 | |
12605 | 194972 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 702 Minna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008741.34582 | 2110880.59687 | 37.776569290768 | -122.413268305085 | (37.776569290768, -122.413268305085) | 8 | 2 | 9 | 28853 | 34 | |||
14143 | 236188 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 149 Otis St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6006722.91202 | 2108754.89026 | 37.7706190820321 | -122.420099772096 | (37.7706190820321, -122.420099772096) | 8 | 2 | 9 | 28853 | 19 | |||
14597 | 106873 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 38 08th St | 4 | Front Yard : Cutout | Tree | Private 2 | Permit Number 769156 | 6008506.93846 | 2111466.36236 | 37.7781645006636 | -122.414120641632 | (37.7781645006636, -122.414120641632) | 8 | 2 | 9 | 28853 | 34 | ||||
14640 | 50694 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 3 | Permit Number 47259 | 6015915.16555 | 2115344.32909 | 37.7892258402606 | -122.388763456582 | (37.7892258402606, -122.388763456582) | 6 | 2 | 9 | 28855 | 6 | |
14807 | 194864 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015802.5335 | 2109067.01209 | 37.7719834911837 | -122.38871476639 | (37.7719834911837, -122.38871476639) | 14 | 3 | 9 | 310 | 20 | |||
15854 | 50686 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 5 | Permit Number 47259 | 6015866.59166 | 2115301.03346 | 37.7891042680871 | -122.388928493857 | (37.7891042680871, -122.388928493857) | 6 | 2 | 9 | 28855 | 6 | |
16042 | 256809 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1098x Geary St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006524 | 2114353 | 37.7859789268864 | -122.421185386363 | (37.7859789268864, -122.421185386363) | 13 | 9 | 9 | 28858 | 36 | ||||
17348 | 194615 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 131 Shipley St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012093.46487 | 2112313.1181 | 37.7806902901516 | -122.401773003447 | (37.7806902901516, -122.401773003447) | 6 | 2 | 9 | 28856 | 34 | |||
17981 | 50697 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 5 | Permit Number 47259 | 6015787.30845 | 2115222.67912 | 37.7888847301024 | -122.389197332691 | (37.7888847301024, -122.389197332691) | 6 | 2 | 9 | 28855 | 6 | |
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 | |||
18872 | 236204 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 148 Otis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006644.17849 | 2108974.66061 | 37.7712180826746 | -122.420387714315 | (37.7712180826746, -122.420387714315) | 8 | 2 | 9 | 28853 | 19 | |||
19492 | 132979 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 477 O'Farrell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6009081.69154 | 2114236.66223 | 37.7858033488003 | -122.412328212304 | (37.7858033488003, -122.412328212304) | 14 | 10 | 9 | 28852 | 36 | |||
19958 | 104685 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 33 08th St | 7 | Front Yard : Yard | Tree | Private 2 | Permit Number 770764 | 6008457.3 | 2111569.1 | 37.7784438055662 | -122.414299630615 | (37.7784438055662, -122.414299630615) | 8 | 2 | 9 | 28853 | 34 | ||||
19999 | 194976 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 148 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008945.71671 | 2110978.00188 | 37.7768482137195 | -122.412568211675 | (37.7768482137195, -122.412568211675) | 8 | 2 | 9 | 28853 | 34 | |||
21033 | 194977 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 148 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008963.54878 | 2110957.0973 | 37.7767918154387 | -122.412505046886 | (37.7767918154387, -122.412505046886) | 8 | 2 | 9 | 28853 | 34 | |||
21264 | 256802 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1098x Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006524 | 2114353 | 37.7859789268864 | -122.421185386363 | (37.7859789268864, -122.421185386363) | 13 | 9 | 9 | 28858 | 36 | ||||
21702 | 256807 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1098x Geary St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006524 | 2114353 | 37.7859789268864 | -122.421185386363 | (37.7859789268864, -122.421185386363) | 13 | 9 | 9 | 28858 | 36 | ||||
22063 | 93539 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 325 China Basin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | 14 | 3 | 9 | 310 | 20 | ||
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 | |||
23132 | 194896 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 390 China Basin St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015135.44967 | 2109081.29606 | 37.7719857179054 | -122.391023277518 | (37.7719857179054, -122.391023277518) | 14 | 3 | 9 | 310 | 20 | |||
23241 | 194937 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 701 China Basin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6014497.15319 | 2108994.00111 | 37.7717105856133 | -122.393225101156 | (37.7717105856133, -122.393225101156) | 14 | 3 | 9 | 310 | 20 | |||
23296 | 194861 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015726.19209 | 2109065.3037 | 37.7719745690081 | -122.388978720114 | (37.7719745690081, -122.388978720114) | 14 | 3 | 9 | 310 | 20 | |||
23579 | 255888 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 50 Columbia Square St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | ||||
24306 | 28905 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 360X 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2006 12:00:00 AM | 7 | 3X3 | 6011830.2607918 | 2111915.3291558 | 37.7795833622831 | -122.402655576198 | (37.7795833622831, -122.402655576198) | 14 | 2 | 9 | 28856 | 34 | ||
24770 | 133003 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 199 Elm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6006752.16305 | 2112715.4808 | 37.7814955593175 | -122.420279738128 | (37.7814955593175, -122.420279738128) | 7 | 9 | 9 | 28852 | 36 | |||
24833 | 104679 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 33 08th St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770764 | 6008457.3 | 2111569.1 | 37.7784438055662 | -122.414299630615 | (37.7784438055662, -122.414299630615) | 8 | 2 | 9 | 28853 | 34 | ||||
24854 | 194890 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 390 China Basin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015326.89047 | 2109090.27617 | 37.7720209965018 | -122.390361691236 | (37.7720209965018, -122.390361691236) | 14 | 3 | 9 | 310 | 20 | |||
24980 | 194903 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 401 Mission Rock St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015232.09162 | 2109377.87139 | 37.7728054103818 | -122.390709711786 | (37.7728054103818, -122.390709711786) | 14 | 3 | 9 | 310 | 20 | |||
24998 | 194906 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 401 Mission Rock St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015306.95007 | 2109382.42409 | 37.7728220640133 | -122.390451083864 | (37.7728220640133, -122.390451083864) | 14 | 3 | 9 | 310 | 20 | |||
25904 | 114505 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 701 Minna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 6008887.99454 | 2110982.8858 | 37.7768583841502 | -122.412768236182 | (37.7768583841502, -122.412768236182) | 8 | 2 | 9 | 28853 | 34 | ||||
25914 | 75352 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 499 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015655 | 2107201 | 37.766851652402 | -122.389094788361 | (37.766851652402, -122.389094788361) | 14 | 3 | 9 | 310 | 29 | ||
26089 | 194795 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 30 Beale St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013669.51914 | 2116270.94493 | 37.7916453933826 | -122.396598157782 | (37.7916453933826, -122.396598157782) | 12 | 2 | 9 | 28855 | 6 | |||
26244 | 256808 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1098x Geary St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006524 | 2114353 | 37.7859789268864 | -122.421185386363 | (37.7859789268864, -122.421185386363) | 13 | 9 | 9 | 28858 | 36 | ||||
26362 | 249404 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 201 Hyde St | 2 | : | Tree | Private 2 | 18 | Width 3ft | 6008044.54094 | 2113134.78651 | 37.7827196103579 | -122.415838420016 | (37.7827196103579, -122.415838420016) | 7 | 10 | 9 | 28852 | 36 | |||
26747 | 194877 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 411 China Basin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016229.27559 | 2109093.14578 | 37.7720788903636 | -122.387240442995 | (37.7720788903636, -122.387240442995) | 14 | 3 | 9 | 310 | 20 | |||
26809 | 194873 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 411 China Basin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6016122.98032 | 2109087.29125 | 37.7720569280033 | -122.387607721645 | (37.7720569280033, -122.387607721645) | 14 | 3 | 9 | 310 | 20 | |||
27023 | 194910 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 402 Mission Rock St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015401.81809 | 2109433.24405 | 37.7729668665718 | -122.390126472677 | (37.7729668665718, -122.390126472677) | 14 | 3 | 9 | 310 | 20 | |||
27272 | 173641 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 657 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012793 | 2114089 | 37.7856054636163 | -122.399477673173 | (37.7856054636163, -122.399477673173) | 6 | 2 | 9 | 28853 | 6 | ||||
27419 | 50141 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 543 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2003 12:00:00 AM | 7 | 3x3 | Permit Number 46867 | 6013539.49892 | 2114829.74341 | 37.7876809533569 | -122.396946939166 | (37.7876809533569, -122.396946939166) | 6 | 2 | 9 | 28855 | 6 | |
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 | |||
28822 | 194614 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 131 Shipley St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012108.33615 | 2112327.33691 | 37.7807301615949 | -122.401722555944 | (37.7807301615949, -122.401722555944) | 6 | 2 | 9 | 28856 | 34 | |||
29062 | 194887 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 390 China Basin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015402.87035 | 2109094.40986 | 37.772036561061 | -122.390099157543 | (37.772036561061, -122.390099157543) | 14 | 3 | 9 | 310 | 20 | |||
29525 | 74025 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 409 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6016159.9 | 2106964.2 | 37.766229426257 | -122.387331885576 | (37.766229426257, -122.387331885576) | 14 | 3 | 9 | 310 | 20 | ||
29541 | 194617 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 131 Shipley St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012071.13963 | 2112290.88253 | 37.7806279905367 | -122.401848674179 | (37.7806279905367, -122.401848674179) | 6 | 2 | 9 | 28856 | 34 | |||
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 | |||
31420 | 194852 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 649 Delancey St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6015686.66814 | 2113218.50724 | 37.7833761496389 | -122.389405522161 | (37.7833761496389, -122.389405522161) | 6 | 2 | 9 | 28856 | 6 | |||
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 | |||
31988 | 132977 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 477 O'Farrell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6009040.946 | 2114232.3262 | 37.7857891565861 | -122.412468874341 | (37.7857891565861, -122.412468874341) | 14 | 10 | 9 | 28852 | 36 | |||
32505 | 90441 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100 Otis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/25/2008 12:00:00 AM | 3 | 3x3 | 6006647.189885 | 2109151.603655 | 37.7717040957938 | -122.420389859033 | (37.7717040957938, -122.420389859033) | 8 | 2 | 9 | 28853 | 19 | ||
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 | |||
33221 | 194788 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 28 Beale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6013555.27864 | 2116393.00814 | 37.7919741918104 | -122.397001993869 | (37.7919741918104, -122.397001993869) | 12 | 2 | 9 | 28855 | 6 | |||
33578 | 90446 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 5 Otis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/25/2008 12:00:00 AM | 3 | 3x3 | 6007136.333421 | 2109596.068929 | 37.7729520436457 | -122.418729402786 | (37.7729520436457, -122.418729402786) | 8 | 2 | 9 | 28853 | 19 | ||
34242 | 249403 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 201 Hyde St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6008040.77723 | 2113154.96679 | 37.7827748089509 | -122.415852870339 | (37.7827748089509, -122.415852870339) | 7 | 10 | 9 | 28852 | 36 | |||
35583 | 132975 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 477 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008996.61863 | 2114222.03393 | 37.7857584087782 | -122.412621507281 | (37.7857584087782, -122.412621507281) | 14 | 10 | 9 | 28852 | 36 | |||
36183 | 194909 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 402 Mission Rock St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015424.78745 | 2109435.25587 | 37.7729736645241 | -122.390047158762 | (37.7729736645241, -122.390047158762) | 14 | 3 | 9 | 310 | 20 | |||
36457 | 28894 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 160X 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2006 12:00:00 AM | 3 | 3x3 | 6010996.3829751 | 2112789.0719885 | 37.7819358639037 | -122.405601889406 | (37.7819358639037, -122.405601889406) | 14 | 2 | 9 | 28853 | 34 | ||
38662 | 194973 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 702 Minna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008713.05969 | 2110854.70585 | 37.7764966120546 | -122.413364323901 | (37.7764966120546, -122.413364323901) | 8 | 2 | 9 | 28853 | 34 | |||
39081 | 17349 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 199X Otis St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 1X1 | 6006751.61671 | 2108600.21847 | 37.7701960073224 | -122.419989504177 | (37.7701960073224, -122.419989504177) | 8 | 4 | 9 | 28853 | 19 | |||
39240 | 194965 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 380 Clementina St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6011526.58461 | 2112400.4179 | 37.7808983438113 | -122.403740270404 | (37.7808983438113, -122.403740270404) | 6 | 2 | 9 | 28853 | 34 | |||
39324 | 107135 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 38 08th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2014 12:00:00 AM | 3x3 | Permit Number 769156 | 6008506.93846 | 2111466.36236 | 37.7781645006636 | -122.414120641632 | (37.7781645006636, -122.414120641632) | 8 | 2 | 9 | 28853 | 34 | |||
39374 | 194897 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 390 China Basin St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015112.61375 | 2109077.97886 | 37.7719753424154 | -122.391102037449 | (37.7719753424154, -122.391102037449) | 14 | 3 | 9 | 310 | 20 | |||
39557 | 194970 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 702 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6008823.53181 | 2110954.10778 | 37.7767757481408 | -122.412989197815 | (37.7767757481408, -122.412989197815) | 8 | 2 | 9 | 28853 | 34 | |||
39676 | 194893 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 390 China Basin St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015251.646 | 2109084.99458 | 37.7720023202774 | -122.39062160073 | (37.7720023202774, -122.39062160073) | 14 | 3 | 9 | 310 | 20 | |||
39678 | 194859 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015665.14575 | 2109062.78658 | 37.7719642735598 | -122.389189710044 | (37.7719642735598, -122.389189710044) | 14 | 3 | 9 | 310 | 20 | |||
40870 | 194960 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 380 Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6011596.99079 | 2112464.71305 | 37.7810788161715 | -122.403501224306 | (37.7810788161715, -122.403501224306) | 6 | 2 | 9 | 28853 | 34 | |||
40988 | 256790 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 199x Cedar St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006524 | 2114353 | 37.7859789268864 | -122.421185386363 | (37.7859789268864, -122.421185386363) | 13 | 9 | 9 | 28858 | 36 | ||||
41406 | 194860 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015703.58503 | 2109064.51023 | 37.7719711371777 | -122.389056864908 | (37.7719711371777, -122.389056864908) | 14 | 3 | 9 | 310 | 20 | |||
41623 | 17341 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 175X Otis St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.420111956743 | (37.7705111956623, -122.420111956743) | 8 | 2 | 9 | 28853 | 19 | |||
42584 | 90443 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 100 Otis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/25/2008 12:00:00 AM | 3 | 3x3 | 6006647.189885 | 2109151.603655 | 37.7717040957938 | -122.420389859033 | (37.7717040957938, -122.420389859033) | 8 | 2 | 9 | 28853 | 19 | ||
43381 | 104682 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 33 08th St | 4 | Front Yard : Yard | Tree | Private 2 | Permit Number 770764 | 6008457.3 | 2111569.1 | 37.7784438055662 | -122.414299630615 | (37.7784438055662, -122.414299630615) | 8 | 2 | 9 | 28853 | 34 | ||||
43546 | 15316 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1680 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006800.8505 | 2108804.3321 | 37.7707592285647 | -122.419833690257 | (37.7707592285647, -122.419833690257) | 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) );