trees
193 rows where qSpecies_id = 256 sorted by Zip Codes
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes ▼ | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39920 | 87842 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 150 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50723 | 6008797.68605 | 2112863.51271 | 37.7820170689709 | -122.413213659581 | (37.7820170689709, -122.413213659581) | 7 | 10 | 9 | 28852 | 36 | |
89763 | 87841 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 150 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50723 | 6008821.92164 | 2112867.33503 | 37.7820289247277 | -122.413130085586 | (37.7820289247277, -122.413130085586) | 7 | 10 | 9 | 28852 | 36 | |
91375 | 87840 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 150 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50723 | 6008834.94947 | 2112868.30248 | 37.7820323124688 | -122.413085083511 | (37.7820323124688, -122.413085083511) | 7 | 10 | 9 | 28852 | 36 | |
79060 | 196334 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 185 Hampshire St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 5ft | 6010020.7902 | 2107448.70721 | 37.7672178649282 | -122.408600163592 | (37.7672178649282, -122.408600163592) | 8 | 4 | 8 | 28853 | 19 | |||
48652 | 196327 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 582 Rhode Island St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6011756.69483 | 2105652.08155 | 37.7623818019909 | -122.402469541836 | (37.7623818019909, -122.402469541836) | 8 | 3 | 8 | 28856 | 29 | ||||
55518 | 196321 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1018 Pennsylvania Ave | 1 | Front Yard : Yard | Tree | Private 2 | 8 | Width 6ft | 6014465.23121 | 2102394.5848 | 37.7535882525988 | -122.392873735151 | (37.7535882525988, -122.392873735151) | 10 | 3 | 8 | 28856 | 29 | |||
77860 | 196324 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2014 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6011723.18554 | 2105150.83196 | 37.761003611654 | -122.40255018945 | (37.761003611654, -122.40255018945) | 10 | 3 | 8 | 28856 | 29 | |||
82129 | 196322 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 320 Pennsylvania Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6014284.29861 | 2105571.05325 | 37.7623000976946 | -122.393721759867 | (37.7623000976946, -122.393721759867) | 10 | 3 | 8 | 28856 | 29 | |||
103932 | 196323 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1922 23rd St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | 6012591.21229 | 2102864.69613 | 37.7547748064319 | -122.399387546319 | (37.7547748064319, -122.399387546319) | 10 | 3 | 8 | 28856 | 29 | ||||
118841 | 196331 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 801 Arkansas St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6013062.01072 | 2103694.01523 | 37.7570781653471 | -122.397817553962 | (37.7570781653471, -122.397817553962) | 10 | 3 | 8 | 28856 | 29 | ||||
127469 | 196326 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 582 Rhode Island St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6011758.07727 | 2105655.26159 | 37.7623906108466 | -122.40246498408 | (37.7623906108466, -122.40246498408) | 8 | 3 | 8 | 28856 | 29 | ||||
132201 | 196330 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 582 Rhode Island St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6011759.95887 | 2105639.7656 | 37.7623481673595 | -122.402457386618 | (37.7623481673595, -122.402457386618) | 8 | 3 | 8 | 28856 | 29 | ||||
142548 | 196328 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 582 Rhode Island St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6011759.42256 | 2105649.40128 | 37.7623745948457 | -122.402459919101 | (37.7623745948457, -122.402459919101) | 8 | 3 | 8 | 28856 | 29 | ||||
143109 | 196325 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 582 Rhode Island St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6011758.16915 | 2105659.78061 | 37.7624030241958 | -122.402464984075 | (37.7624030241958, -122.402464984075) | 8 | 3 | 8 | 28856 | 29 | ||||
148401 | 196332 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 801 Arkansas St | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6013061.70024 | 2103702.02862 | 37.7571001510787 | -122.39781918981 | (37.7571001510787, -122.39781918981) | 10 | 3 | 8 | 28856 | 29 | ||||
153709 | 196329 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 582 Rhode Island St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6011758.91837 | 2105646.20338 | 37.7623657859795 | -122.402461438042 | (37.7623657859795, -122.402461438042) | 8 | 3 | 8 | 28856 | 29 | ||||
174153 | 196333 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 801 Arkansas St | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6013061.90076 | 2103711.91526 | 37.7571273088036 | -122.397819189808 | (37.7571273088036, -122.397819189808) | 10 | 3 | 8 | 28856 | 29 | ||||
77581 | 27414 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2300 Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 12 | 9 | 6005892.4011 | 2118361.12861 | 37.7969486190501 | -122.423655628528 | (37.7969486190501, -122.423655628528) | 13 | 9 | 1 | 28858 | 32 | |||
98934 | 23463 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2300 Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 12 | 9 | 6005896.8378 | 2118341.60488 | 37.7968952622641 | -122.423638887645 | (37.7968952622641, -122.423638887645) | 13 | 9 | 1 | 28858 | 32 | |||
115454 | 135863 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 8 Kimball Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6007998.64807 | 2116497.60836 | 37.7919505198577 | -122.416235439221 | (37.7919505198577, -122.416235439221) | 5 | 1 | 10 | 28858 | 21 | |||
154527 | 27415 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2300 Van Ness Ave | 3 | Median : Cutout | Tree | DPW 1 | 12 | 9 | 6005889.8891 | 2118381.22689 | 37.7970036620469 | -122.423665750374 | (37.7970036620469, -122.423665750374) | 13 | 9 | 1 | 28858 | 32 | |||
192023 | 135862 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 8 Kimball Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6008000.71273 | 2116486.83875 | 37.7919210652522 | -122.416227532369 | (37.7919210652522, -122.416227532369) | 5 | 1 | 10 | 28858 | 21 | |||
17385 | 29888 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1126 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 6005721.57126 | 2102405.52669 | 37.7531287556897 | -122.423112046809 | (37.7531287556897, -122.423112046809) | 2 | 4 | 5 | 28859 | 19 | |||
22709 | 237899 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 401 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007240.84354 | 2104941.30252 | 37.760177031273 | -122.418037841569 | (37.760177031273, -122.418037841569) | 2 | 4 | 7 | 28859 | 19 | |||
32097 | 237896 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 3337 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007507.32958 | 2100885.13303 | 37.7490547108172 | -122.416828817304 | (37.7490547108172, -122.416828817304) | 2 | 4 | 7 | 28859 | 19 | |||
32573 | 237874 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 160 Coso Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6007471.90669 | 2099585.18417 | 37.7454833509872 | -122.416859223383 | (37.7454833509872, -122.416859223383) | 2 | 7 | 7 | 28859 | 2 | ||||
43672 | 237890 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 101 Bradford St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 10ft | 6009586.52326 | 2097993.57219 | 37.7412318491774 | -122.409434875633 | (37.7412318491774, -122.409434875633) | 10 | 7 | 7 | 28859 | 2 | |||
49088 | 237889 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 722 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007362.196 | 2095569.17155 | 37.7344500984995 | -122.416954096469 | (37.7344500984995, -122.416954096469) | 2 | 7 | 7 | 28859 | 2 | |||
55742 | 237879 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 400 Prospect Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6006275.05202 | 2097644.49058 | 37.7400872496179 | -122.420860008587 | (37.7400872496179, -122.420860008587) | 2 | 7 | 7 | 28859 | 2 | ||||
68350 | 237883 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 74 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005237.83328 | 2105067.23866 | 37.7604098837378 | -122.424974271161 | (37.7604098837378, -122.424974271161) | 2 | 4 | 5 | 28859 | 19 | |||
75539 | 237900 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2495 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008886.65088 | 2103959.41051 | 37.7575734723481 | -122.412276352893 | (37.7575734723481, -122.412276352893) | 2 | 4 | 7 | 28859 | 19 | |||
82140 | 237898 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1087 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6009471.98593 | 2102823.41576 | 37.754487114207 | -122.410171817891 | (37.754487114207, -122.410171817891) | 2 | 4 | 7 | 28859 | 19 | |||
91173 | 237878 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 400 Prospect Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6006265.83898 | 2097650.58343 | 37.7401034599156 | -122.420892296036 | (37.7401034599156, -122.420892296036) | 2 | 7 | 7 | 28859 | 2 | ||||
103259 | 237897 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1351 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6009296.40092 | 2101303.05308 | 37.7503026946211 | -122.410671678154 | (37.7503026946211, -122.410671678154) | 2 | 4 | 7 | 28859 | 19 | |||
104386 | 237875 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 200 Kingston St | 6 | Front Yard : Yard | Tree | Private 2 | 3 | 6006243.16762 | 2098035.54696 | 37.7411592055212 | -122.420998010444 | (37.7411592055212, -122.420998010444) | 2 | 7 | 7 | 28859 | 2 | ||||
113311 | 237891 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 61 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007462.84884 | 2099058.94868 | 37.7440379165229 | -122.416853268066 | (37.7440379165229, -122.416853268066) | 2 | 7 | 7 | 28859 | 2 | |||
123915 | 237895 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 101 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6010025.93602 | 2099871.47095 | 37.7464127607541 | -122.408047938455 | (37.7464127607541, -122.408047938455) | 2 | 7 | 7 | 28859 | 2 | |||
127191 | 237892 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 61 Elsie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007463.8743 | 2099061.81517 | 37.7440458449445 | -122.416849925291 | (37.7440458449445, -122.416849925291) | 2 | 7 | 7 | 28859 | 2 | |||
141525 | 237882 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 814 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008528.1634 | 2103776.1584 | 37.7570501811472 | -122.413503191821 | (37.7570501811472, -122.413503191821) | 2 | 4 | 7 | 28859 | 19 | |||
141635 | 237881 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 400 Prospect Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6006228.09651 | 2097633.90585 | 37.7400555395259 | -122.42102161048 | (37.7400555395259, -122.42102161048) | 2 | 7 | 7 | 28859 | 2 | ||||
152943 | 237894 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 101 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6010034.07785 | 2099858.60697 | 37.7463778949392 | -122.408018877775 | (37.7463778949392, -122.408018877775) | 2 | 7 | 7 | 28859 | 2 | |||
171201 | 237876 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 400 Prospect Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6006280.46143 | 2097653.37775 | 37.740111956701 | -122.420841935814 | (37.740111956701, -122.420841935814) | 2 | 7 | 7 | 28859 | 2 | ||||
177804 | 237877 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 400 Prospect Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6006273.45555 | 2097651.54951 | 37.7401065418729 | -122.420866029569 | (37.7401065418729, -122.420866029569) | 2 | 7 | 7 | 28859 | 2 | ||||
188214 | 237893 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 48 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6007622.58869 | 2099939.38246 | 37.7464643746486 | -122.416363270665 | (37.7464643746486, -122.416363270665) | 2 | 7 | 7 | 28859 | 2 | |||
193384 | 237880 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 400 Prospect Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6006230.93863 | 2097643.52174 | 37.7400821028175 | -122.421012466149 | (37.7400821028175, -122.421012466149) | 2 | 7 | 7 | 28859 | 2 | ||||
5265 | 214338 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 10 Granada Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995645.44763 | 2089954.09949 | 37.7183664125644 | -122.4570564727 | (37.7183664125644, -122.4570564727) | 9 | 8 | 6 | 28861 | 24 | |||
15259 | 178849 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 13 Liebig St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 1ft | 5995911.23484 | 2086261.34028 | 37.7082422172863 | -122.455870959398 | (37.7082422172863, -122.455870959398) | 7 | 6 | 28861 | 25 | ||||
36902 | 214339 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 10 Granada Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995645.61653 | 2089973.75632 | 37.7184203952771 | -122.457057309964 | (37.7184203952771, -122.457057309964) | 9 | 8 | 6 | 28861 | 24 | |||
62395 | 178850 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 178 Dublin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 6004207.2935 | 2089409.65664 | 37.7173594632439 | -122.427422984776 | (37.7173594632439, -122.427422984776) | 9 | 7 | 6 | 28861 | 5 | |||
64901 | 214336 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 165 Marston Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5998449.68813 | 2093175.59235 | 37.727372526598 | -122.447595198264 | (37.727372526598, -122.447595198264) | 9 | 7 | 4 | 28861 | 40 | ||||
68421 | 178851 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 642 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6002153.25457 | 2090190.26057 | 37.719386440714 | -122.434578616011 | (37.719386440714, -122.434578616011) | 9 | 7 | 6 | 28861 | 5 | |||
70720 | 214337 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 10 Granada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995645.82098 | 2089943.68701 | 37.7183378437938 | -122.457054429431 | (37.7183378437938, -122.457054429431) | 9 | 8 | 6 | 28861 | 24 | |||
71671 | 178852 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 642 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 1ft | 6003293.17352 | 2089466.63658 | 37.71746417401 | -122.430586734103 | (37.71746417401, -122.430586734103) | 9 | 7 | 6 | 28861 | 5 | |||
129479 | 214340 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 10 Granada Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995647.31789 | 2089997.48145 | 37.7184856365862 | -122.457053144299 | (37.7184856365862, -122.457053144299) | 9 | 8 | 6 | 28861 | 24 | |||
166266 | 214341 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 144 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995498.01894 | 2089341.34439 | 37.7166754640834 | -122.457521759431 | (37.7166754640834, -122.457521759431) | 9 | 8 | 6 | 28861 | 24 | |||
188969 | 214342 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 331 Lakeview Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5996752.352 | 2089647.99235 | 37.7175894189894 | -122.453208302426 | (37.7175894189894, -122.453208302426) | 9 | 8 | 6 | 28861 | 24 | |||
7816 | 237931 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 18 Temple St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5999994.62286 | 2105880.85812 | 37.7623463174434 | -122.443166486857 | (37.7623463174434, -122.443166486857) | 15 | 5 | 5 | 28862 | 3 | |||
16370 | 237937 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 272 Corbett Ave | 6 | Side Yard : Yard | Tree | Private 2 | 4 | Width 3ft | 5999630.47363 | 2105335.88644 | 37.7608291899486 | -122.444386772443 | (37.7608291899486, -122.444386772443) | 15 | 5 | 5 | 28862 | 3 | |||
28309 | 237924 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 47 Seward St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 6000838.40395 | 2104323.17709 | 37.7581173832271 | -122.440136465844 | (37.7581173832271, -122.440136465844) | 2 | 4 | 5 | 28862 | 38 | |||
39718 | 237908 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 3911 21st St | 4 | Side Yard : Yard | Tree | Private 2 | 18 | 6002345.78312 | 2103531.79558 | 37.7560301412935 | -122.43486671293 | (37.7560301412935, -122.43486671293) | 2 | 4 | 5 | 28862 | 22 | ||||
41063 | 237904 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 215 Grand View Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6000729.50411 | 2103183.58085 | 37.7549821289444 | -122.440431357129 | (37.7549821289444, -122.440431357129) | 2 | 4 | 5 | 28862 | 22 | |||
47000 | 237936 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 272 Corbett Ave | 5 | Side Yard : Yard | Tree | Private 2 | 4 | Width 3ft | 5999637.58135 | 2105322.06296 | 37.7607916396321 | -122.444361196632 | (37.7607916396321, -122.444361196632) | 15 | 5 | 5 | 28862 | 3 | |||
51337 | 237909 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 3911 21st St | 5 | Side Yard : Yard | Tree | Private 2 | 17 | 6002350.80679 | 2103530.36749 | 37.7560265053261 | -122.434849237305 | (37.7560265053261, -122.434849237305) | 2 | 4 | 5 | 28862 | 22 | ||||
63473 | 237903 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 4120 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003087.27911 | 2100682.59751 | 37.7482489884214 | -122.432098917134 | (37.7482489884214, -122.432098917134) | 2 | 4 | 5 | 28862 | 22 | |||
65407 | 237928 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 310 Liberty St | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 6004144.43295 | 2103938.76991 | 37.7572495536268 | -122.428675392374 | (37.7572495536268, -122.428675392374) | 2 | 4 | 5 | 28862 | 3 | |||
79272 | 237927 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 4780 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999842.98473 | 2104684.38076 | 37.7590524389352 | -122.44360498999 | (37.7590524389352, -122.44360498999) | 2 | 4 | 5 | 28862 | 3 | |||
81293 | 237911 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 414 Collingwood St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6002101.71196 | 2103425.35357 | 37.7557240165608 | -122.435703175975 | (37.7557240165608, -122.435703175975) | 2 | 4 | 5 | 28862 | 22 | ||||
90527 | 237920 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1237 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003246.87227 | 2101064.36652 | 37.7493062835598 | -122.43157430031 | (37.7493062835598, -122.43157430031) | 2 | 4 | 5 | 28862 | 22 | |||
94586 | 237901 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 185 Graystone Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999340.20511 | 2104037.69867 | 37.7572481219159 | -122.445297337804 | (37.7572481219159, -122.445297337804) | 2 | 5 | 5 | 28862 | 3 | |||
96174 | 237905 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 3937 21st St | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 6002227.46362 | 2103520.47073 | 37.7559923274905 | -122.435275090576 | (37.7559923274905, -122.435275090576) | 2 | 4 | 5 | 28862 | 22 | ||||
99778 | 237912 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 3974 22nd St | 3 | : | Tree | Private 2 | 20 | 6002002.92886 | 2102961.58207 | 37.7544449998516 | -122.436011614667 | (37.7544449998516, -122.436011614667) | 2 | 4 | 5 | 28862 | 22 | ||||
105432 | 237938 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 272 Corbett Ave | 7 | Side Yard : Yard | Tree | Private 2 | 4 | Width 3ft | 5999643.14509 | 2105335.62313 | 37.7608291899369 | -122.44434292871 | (37.7608291899369, -122.44434292871) | 15 | 5 | 5 | 28862 | 3 | |||
107179 | 237926 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 23 Seward St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | Width 3ft | 6001036.33691 | 2104228.71408 | 37.7578692773617 | -122.439445158788 | (37.7578692773617, -122.439445158788) | 2 | 4 | 5 | 28862 | 38 | |||
112904 | 237921 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1235 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003247.45246 | 2101075.30094 | 37.7493363397968 | -122.431573074532 | (37.7493363397968, -122.431573074532) | 2 | 4 | 5 | 28862 | 22 | |||
116631 | 237922 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 167 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002705.54642 | 2104925.31615 | 37.7598768339596 | -122.433722125974 | (37.7598768339596, -122.433722125974) | 2 | 4 | 5 | 28862 | 3 | |||
118298 | 237930 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 4119 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002901.50765 | 2104134.40267 | 37.7577162927848 | -122.432987885294 | (37.7577162927848, -122.432987885294) | 2 | 4 | 5 | 28862 | 3 | |||
131053 | 237923 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 552 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6002969.94721 | 2104996.10401 | 37.7600861997348 | -122.432812750413 | (37.7600861997348, -122.432812750413) | 2 | 4 | 5 | 28862 | 3 | |||
144998 | 237910 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 414 Collingwood St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | 6002101.86364 | 2103432.68582 | 37.7557441577743 | -122.435703175979 | (37.7557441577743, -122.435703175979) | 2 | 4 | 5 | 28862 | 22 | ||||
145267 | 237932 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 101 Lower Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6000437.08664 | 2106174.23917 | 37.7631770886698 | -122.441657229316 | (37.7631770886698, -122.441657229316) | 15 | 5 | 5 | 28862 | 3 | |||
157371 | 237934 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 101 Lower Ter | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6000443.26422 | 2106174.87839 | 37.76317919578 | -122.441635909067 | (37.76317919578, -122.441635909067) | 15 | 5 | 5 | 28862 | 3 | |||
157438 | 237939 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 273 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6000450.96835 | 2106715.6224 | 37.764664383877 | -122.441648071496 | (37.764664383877, -122.441648071496) | 15 | 5 | 5 | 28862 | 3 | |||
160687 | 237907 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 3911 21st St | 3 | Side Yard : Yard | Tree | Private 2 | 12 | 6002340.71018 | 2103530.84091 | 37.7560272319733 | -122.434884188553 | (37.7560272319733, -122.434884188553) | 2 | 4 | 5 | 28862 | 22 | ||||
169227 | 237935 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 272 Corbett Ave | 4 | Side Yard : Yard | Tree | Private 2 | 6 | Width 3ft | 5999636.03267 | 2105332.26436 | 37.7608195617885 | -122.444367285948 | (37.7608195617885, -122.444367285948) | 15 | 5 | 5 | 28862 | 3 | |||
174026 | 237902 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 4120 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003116.41859 | 2100685.05072 | 37.7482573763929 | -122.43199832888 | (37.7482573763929, -122.43199832888) | 2 | 4 | 5 | 28862 | 22 | |||
175069 | 237929 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 741 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002446.47935 | 2103887.09921 | 37.7570114365341 | -122.434543876122 | (37.7570114365341, -122.434543876122) | 2 | 4 | 5 | 28862 | 3 | |||
177113 | 237933 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 101 Lower Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6000440.92976 | 2106173.77589 | 37.7631760355812 | -122.441643904037 | (37.7631760355812, -122.441643904037) | 15 | 5 | 5 | 28862 | 3 | |||
187537 | 237925 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 37 Seward St | 7 | Front Yard : Yard | Tree | Private 2 | 14 | Width 3ft | 6000968.93807 | 2104244.5163 | 37.7579088304528 | -122.439679384512 | (37.7579088304528, -122.439679384512) | 2 | 4 | 5 | 28862 | 38 | |||
12969 | 135864 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2451 Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6002234.27154 | 2116544.43758 | 37.7917532859283 | -122.436183536242 | (37.7917532859283, -122.436183536242) | 13 | 9 | 1 | 29490 | 27 | |||
54806 | 135866 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 200 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999037.7073 | 2115878.6146 | 37.7897429809958 | -122.447195652882 | (37.7897429809958, -122.447195652882) | 13 | 6 | 1 | 29490 | 31 | |||
97792 | 139121 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1501 LAGUNA ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004511.3378 | 2114128.6273 | 37.785249186429 | -122.428132654809 | (37.785249186429, -122.428132654809) | 13 | 9 | 11 | 29490 | 13 | |||
104781 | 18905 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2602 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6002286.89222 | 2115779.97328 | 37.789657253131 | -122.435946744753 | (37.789657253131, -122.435946744753) | 13 | 6 | 1 | 29490 | 27 | |||
110895 | 135872 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2550 Pierce St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6001695.18556 | 2117280.97246 | 37.7937449767048 | -122.438101551856 | (37.7937449767048, -122.438101551856) | 13 | 6 | 1 | 29490 | 27 | |||
145318 | 51089 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2550 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/2004 12:00:00 AM | 6 | Permit Number 47546 | 6001713.34736 | 2117152.10978 | 37.7933921861489 | -122.438029475688 | (37.7933921861489, -122.438029475688) | 13 | 6 | 1 | 29490 | 27 | ||
149035 | 135870 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2550 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6001706.98139 | 2117190.01379 | 37.7934958986807 | -122.438054218747 | (37.7934958986807, -122.438054218747) | 13 | 6 | 1 | 29490 | 27 | |||
159830 | 135871 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2550 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6001702.83254 | 2117214.86813 | 37.7935639062924 | -122.43807035526 | (37.7935639062924, -122.43807035526) | 13 | 6 | 1 | 29490 | 27 | |||
160624 | 68433 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2518 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1993 12:00:00 AM | 3 | Permit Number 32286 | 6002013.47223 | 2116725.04565 | 37.7922366418513 | -122.436960435397 | (37.7922366418513, -122.436960435397) | 13 | 6 | 1 | 29490 | 27 | ||
167208 | 135869 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2550 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6001710.05375 | 2117173.2312 | 37.7934499927743 | -122.438042385449 | (37.7934499927743, -122.438042385449) | 13 | 6 | 1 | 29490 | 27 | |||
186784 | 58839 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2385 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1979 12:00:00 AM | 8 | Permit Number 18096 | 6002233.54572 | 2117374.3754 | 37.7940320393926 | -122.436245468077 | (37.7940320393926, -122.436245468077) | 13 | 9 | 1 | 29490 | 27 | ||
187535 | 135865 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2518 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001998.80283 | 2116724.02313 | 37.7922330004913 | -122.437011118472 | (37.7922330004913, -122.437011118472) | 13 | 6 | 1 | 29490 | 27 | |||
13595 | 183564 | DPW Maintained 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 2595 30th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5987057.6296 | 2097628.3948 | 37.7389411183073 | -122.487303955513 | (37.7389411183073, -122.487303955513) | 1 | 8 | 3 | 29491 | 35 |
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) );