trees
1,914 rows where qSpecies_id = 45 sorted by Police 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 149 | 244279 | Undocumented 4 | :: 45 | 585 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004230.7823 | 2110095.842 | 37.7741602789386 | -122.428815691218 | (37.7741602789386, -122.428815691218) | 7 | 9 | 11 | 28852 | 10 | |||
| 192 | 137920 | DPW Maintained 1 | :: 45 | 2028 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6002940.7431 | 2115305.2702 | 37.7883909617368 | -122.433650548643 | (37.7883909617368, -122.433650548643) | 13 | 9 | 1 | 29490 | 27 | |||
| 214 | 138888 | DPW Maintained 1 | :: 45 | 675 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004166.2354 | 2110619.5066 | 37.7755944800015 | -122.429076315191 | (37.7755944800015, -122.429076315191) | 7 | 9 | 11 | 28852 | 10 | |||
| 232 | 228435 | DPW Maintained 1 | :: 45 | 178 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004070 | 2107898 | 37.7681164387884 | -122.429215116616 | (37.7681164387884, -122.429215116616) | 7 | 9 | 5 | 28862 | 3 | |||
| 320 | 228444 | DPW Maintained 1 | :: 45 | 399 Haight St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6004268.91864 | 2109406.82097 | 37.7722705538615 | -122.428634644993 | (37.7722705538615, -122.428634644993) | 7 | 9 | 11 | 28852 | 10 | |||
| 326 | 228441 | DPW Maintained 1 | :: 45 | 419 Haight St | 1 | : | Tree | DPW 1 | 04/08/2008 12:00:00 AM | 6 | Width 3ft | 6004104.36681 | 2109385.12417 | 37.7722016657998 | -122.429202297052 | (37.7722016657998, -122.429202297052) | 7 | 9 | 11 | 29492 | 10 | ||
| 354 | 141882 | DPW Maintained 1 | :: 45 | 1160 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003839.6945 | 2112655.4467 | 37.7811661774464 | -122.430351190021 | (37.7811661774464, -122.430351190021) | 7 | 9 | 11 | 29490 | 41 | |||
| 386 | 143336 | DPW Maintained 1 | :: 45 | 1858 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004106.6848 | 2118733.7418 | 37.797870758582 | -122.429861223474 | (37.797870758582, -122.429861223474) | 13 | 9 | 1 | 57 | 17 | |||
| 532 | 261313 | Permitted Site 7 | :: 45 | 2700 Broadway | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/31/2019 12:00:00 AM | 3 | 6x40 | 6000687.88763 | 2117206.96839 | 37.7934844433083 | -122.441581569821 | (37.7934844433083, -122.441581569821) | 13 | 9 | 1 | 57 | 27 | ||
| 803 | 105089 | Significant Tree 6 | :: 45 | 344 Fulton St | 9 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
| 2959 | 141420 | DPW Maintained 1 | :: 45 | 550 IVY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004578.5445 | 2111046.5078 | 37.7767902513835 | -122.427680466931 | (37.7767902513835, -122.427680466931) | 7 | 9 | 11 | 28852 | 10 | |||
| 3262 | 143122 | DPW Maintained 1 | :: 45 | 1965 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003008.0203 | 2119542.9474 | 37.8000303489096 | -122.433720773421 | (37.8000303489096, -122.433720773421) | 13 | 9 | 1 | 57 | 17 | |||
| 3549 | 141425 | DPW Maintained 1 | :: 45 | 301 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005907.6073 | 2110863.9151 | 37.7763639855674 | -122.423069853164 | (37.7763639855674, -122.423069853164) | 7 | 9 | 11 | 28852 | 10 | |||
| 5583 | 244247 | Undocumented 4 | :: 45 | 200 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005673.0642 | 2110022.689 | 37.7740409443959 | -122.423821374378 | (37.7740409443959, -122.423821374378) | 7 | 9 | 11 | 28852 | 10 | |||
| 5914 | 254656 | Private 9 | :: 45 | 640 Larch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004524 | 2112776 | 37.781535924842 | -122.427992425483 | (37.781535924842, -122.427992425483) | 7 | 9 | 11 | 29490 | 41 | ||||
| 7226 | 139441 | DPW Maintained 1 | :: 45 | 501 GROVE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005361.8674 | 2111299.9206 | 37.7775303390293 | -122.424988750303 | (37.7775303390293, -122.424988750303) | 7 | 9 | 11 | 28852 | 10 | |||
| 7664 | 261543 | Permitted Site 7 | :: 45 | 1305 Lombard St | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 01/17/2020 12:00:00 AM | 3 | 20x5 | 6006114.74348 | 2120010.24127 | 37.8014892121583 | -122.423003541085 | (37.8014892121583, -122.423003541085) | 13 | 9 | 1 | 28858 | 32 | ||
| 7704 | 140222 | DPW Maintained 1 | :: 45 | 610 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003683.3616 | 2110416.1551 | 37.7750087812949 | -122.430732178175 | (37.7750087812949, -122.430732178175) | 7 | 9 | 11 | 29492 | 10 | |||
| 8883 | 261542 | Permitted Site 7 | :: 45 | 1305 Lombard St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 01/17/2020 12:00:00 AM | 3 | 10x5 | 6006114.74348 | 2120010.24127 | 37.8014892121583 | -122.423003541085 | (37.8014892121583, -122.423003541085) | 13 | 9 | 1 | 28858 | 32 | ||
| 13385 | 244231 | DPW Maintained 1 | :: 45 | 576 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6003405.9505 | 2109334.219 | 37.7720223304628 | -122.431614542708 | (37.7720223304628, -122.431614542708) | 15 | 9 | 11 | 29492 | 10 | |||
| 15911 | 105081 | Significant Tree 6 | :: 45 | 344 Fulton St | 1 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
| 16988 | 251724 | DPW Maintained 1 | :: 45 | 1630 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2017 12:00:00 AM | 3 | 3x3 | 6006933.88533 | 2116748.92044 | 37.7925806317422 | -122.419937373279 | (37.7925806317422, -122.419937373279) | 13 | 9 | 10 | 28858 | 32 | ||
| 17108 | 105086 | Significant Tree 6 | :: 45 | 344 Fulton St | 6 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
| 17409 | 228439 | DPW Maintained 1 | :: 45 | 589 Haight St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6003347.45965 | 2109278.2341 | 37.7718652941806 | -122.431812868891 | (37.7718652941806, -122.431812868891) | 15 | 9 | 11 | 29492 | 10 | |||
| 19909 | 139776 | DPW Maintained 1 | :: 45 | 1265 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004800.935 | 2113296.4778 | 37.7829806915655 | -122.427071445409 | (37.7829806915655, -122.427071445409) | 7 | 9 | 11 | 28858 | 41 | |||
| 22031 | 254088 | DPW Maintained 1 | :: 45 | 2520 Broadway | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/22/2017 12:00:00 AM | 3 | 3.5x4.9 | 6001556.59478 | 2117325.5311 | 37.7938594403451 | -122.438584281493 | (37.7938594403451, -122.438584281493) | 13 | 9 | 1 | 57 | 27 | ||
| 22093 | 254089 | DPW Maintained 1 | :: 45 | 2520 Broadway | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/22/2017 12:00:00 AM | 3 | 5x4.9 | 6001556.59478 | 2117325.5311 | 37.7938594403451 | -122.438584281493 | (37.7938594403451, -122.438584281493) | 13 | 9 | 1 | 57 | 27 | ||
| 25087 | 140401 | DPW Maintained 1 | :: 45 | 650 WILLOW ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004290.5512 | 2113088.0425 | 37.7823795059387 | -122.428822298842 | (37.7823795059387, -122.428822298842) | 7 | 9 | 11 | 29490 | 41 | |||
| 25364 | 244493 | DPW Maintained 1 | :: 45 | 418 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/30/2011 12:00:00 AM | 2 | Width 0ft | 6004092.0994 | 2109430.4944 | 37.7723255469078 | -122.429247966827 | (37.7723255469078, -122.429247966827) | 7 | 9 | 11 | 29492 | 10 | ||
| 26240 | 115259 | DPW Maintained 1 | :: 45 | 2130 Jackson St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/21/2016 12:00:00 AM | 6x12 | 6003918.8 | 2117004 | 37.7931106894063 | -122.430387878845 | (37.7931106894063, -122.430387878845) | 13 | 9 | 1 | 29490 | 27 | ||||
| 26648 | 137600 | DPW Maintained 1 | :: 45 | 1962 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003923.2555 | 2115244.7298 | 37.7882804323817 | -122.430246893129 | (37.7882804323817, -122.430246893129) | 13 | 9 | 11 | 29490 | 27 | |||
| 27689 | 228438 | DPW Maintained 1 | :: 45 | 597 Haight St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6003321.74278 | 2109274.92244 | 37.7718547433349 | -122.431901588786 | (37.7718547433349, -122.431901588786) | 15 | 9 | 11 | 29492 | 10 | |||
| 27887 | 140046 | DPW Maintained 1 | :: 45 | 666 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005395.2334 | 2111605.7927 | 37.7783720737797 | -122.424895092854 | (37.7783720737797, -122.424895092854) | 7 | 9 | 11 | 28852 | 10 | |||
| 29183 | 139164 | Undocumented 4 | :: 45 | 1975 POST ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6002726.0596 | 2114048.1262 | 37.7849269803652 | -122.434303405747 | (37.7849269803652, -122.434303405747) | 13 | 9 | 11 | 29490 | 13 | ||||
| 29489 | 140392 | DPW Maintained 1 | :: 45 | 1460 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6002728.4059 | 2113323.2276 | 37.7829367252892 | -122.434243446651 | (37.7829367252892, -122.434243446651) | 15 | 9 | 11 | 29490 | 41 | |||
| 30439 | 10286 | DPW Maintained 1 | :: 45 | 412 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3x3 | 6004126.8809 | 2109434.3591 | 37.7723381274034 | -122.429127930043 | (37.7723381274034, -122.429127930043) | 7 | 9 | 11 | 29492 | 10 | |||
| 30541 | 253834 | DPW Maintained 1 | :: 45 | 747 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | 6006860.78535 | 2113242.76542 | 37.7829494746502 | -122.419941385136 | (37.7829494746502, -122.419941385136) | 7 | 9 | 9 | 28852 | 36 | |||
| 30863 | 95250 | DPW Maintained 1 | :: 45 | 57 Avila St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767151 | 6001050.95383 | 2119955.94053 | 37.8010530753849 | -122.440522591565 | (37.8010530753849, -122.440522591565) | 13 | 9 | 1 | 57 | 17 | |
| 31406 | 140210 | DPW Maintained 1 | :: 45 | 890 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003670.0896 | 2110760.6625 | 37.7759539617211 | -122.430802679477 | (37.7759539617211, -122.430802679477) | 7 | 9 | 11 | 29492 | 10 | |||
| 31946 | 245835 | Undocumented 4 | :: 45 | 451 Fell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005269.6444 | 2110584.5711 | 37.7755609539167 | -122.4252568647 | (37.7755609539167, -122.4252568647) | 7 | 9 | 11 | 28852 | 10 | |||
| 32819 | 142271 | DPW Maintained 1 | :: 45 | 556 FELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004757.9319 | 2110570.0874 | 37.7754922630352 | -122.427025971185 | (37.7754922630352, -122.427025971185) | 7 | 9 | 11 | 28852 | 10 | |||
| 33264 | 138887 | DPW Maintained 1 | :: 45 | 679 LINDEN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004146.8152 | 2110617.8324 | 37.7755887837316 | -122.429143374995 | (37.7755887837316, -122.429143374995) | 7 | 9 | 11 | 28852 | 10 | |||
| 34489 | 141913 | DPW Maintained 1 | :: 45 | 900 MCALLISTER ST | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004416.1749 | 2111910.2001 | 37.7791525518541 | -122.428303723303 | (37.7791525518541, -122.428303723303) | 7 | 9 | 11 | 29490 | 41 | |||
| 35856 | 253828 | DPW Maintained 1 | :: 45 | 825 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | 6007000.12586 | 2113749.24795 | 37.7843480014325 | -122.419495267967 | (37.7843480014325, -122.419495267967) | 7 | 9 | 9 | 28858 | 36 | |||
| 36178 | 108990 | Undocumented 4 | :: 45 | 2073-2099X Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999311.1 | 2121145.9 | 37.8042211586385 | -122.446628874501 | (37.8042211586385, -122.446628874501) | 13 | 9 | 1 | 57 | 17 | |||||
| 38066 | 139933 | DPW Maintained 1 | :: 45 | 800 GOUGH ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005708.0541 | 2112525.3709 | 37.7809146750444 | -122.42387833426 | (37.7809146750444, -122.42387833426) | 7 | 9 | 11 | 28852 | 41 | |||
| 38200 | 141748 | DPW Maintained 1 | :: 45 | 2 HOLLIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004017.2728 | 2113191.4555 | 37.7826479811826 | -122.429775099989 | (37.7826479811826, -122.429775099989) | 7 | 9 | 11 | 29490 | 41 | |||
| 41987 | 139753 | DPW Maintained 1 | :: 45 | 1171 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005547.6328 | 2113641.325 | 37.7839697525349 | -122.424512713511 | (37.7839697525349, -122.424512713511) | 7 | 9 | 11 | 28858 | 41 | |||
| 45232 | 244230 | DPW Maintained 1 | :: 45 | 546 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6003542.3247 | 2109354.0057 | 37.7720843887684 | -122.431144226547 | (37.7720843887684, -122.431144226547) | 15 | 9 | 11 | 29492 | 10 | |||
| 45444 | 10257 | DPW Maintained 1 | :: 45 | 155 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2006 12:00:00 AM | 6 | 3X3 | 6005354.14588 | 2109555.43017 | 37.7727399559066 | -122.424891318606 | (37.7727399559066, -122.424891318606) | 7 | 9 | 11 | 28852 | 10 | ||
| 46237 | 140400 | DPW Maintained 1 | :: 45 | 650 WILLOW ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004364.2248 | 2113098.7472 | 37.7824130679555 | -122.428568183869 | (37.7824130679555, -122.428568183869) | 7 | 9 | 11 | 29490 | 41 | |||
| 48617 | 228447 | DPW Maintained 1 | :: 45 | 365 Haight St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6004400.01174 | 2109424.00964 | 37.7723251679145 | -122.428182407399 | (37.7723251679145, -122.428182407399) | 7 | 9 | 11 | 28852 | 10 | |||
| 49325 | 10299 | DPW Maintained 1 | :: 45 | 559 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6003469.25661 | 2109295.83619 | 37.7719205287291 | -122.431392821626 | (37.7719205287291, -122.431392821626) | 15 | 9 | 11 | 29492 | 10 | |||
| 50945 | 244341 | DPW Maintained 1 | :: 45 | 442 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003210.2759 | 2109856.6606 | 37.7734457335057 | -122.432328715157 | (37.7734457335057, -122.432328715157) | 15 | 9 | 11 | 29492 | 10 | |||
| 51930 | 244131 | DPW Maintained 1 | :: 45 | 322 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004550.5333 | 2109497.9798 | 37.7725367873822 | -122.42766701053 | (37.7725367873822, -122.42766701053) | 7 | 9 | 11 | 28852 | 10 | |||
| 52125 | 32457 | Permitted Site 7 | :: 45 | 210 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | Permit Number 36972 | 6003808.4224833 | 2109079.21792679 | 37.7713449641267 | -122.430204165931 | (37.7713449641267, -122.430204165931) | 7 | 9 | 11 | 29492 | 10 | ||
| 53078 | 255962 | Permitted Site 7 | :: 45 | 2518 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 08/08/2018 12:00:00 AM | 3 | 5x7 | 6003674.59495 | 2116996.308 | 37.7930757331753 | -122.431232293197 | (37.7930757331753, -122.431232293197) | 13 | 9 | 1 | 29490 | 27 | ||
| 53197 | 121045 | Undocumented 4 | :: 45 | 2316 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006394 | 2118785 | 37.7981407640584 | -122.421950099682 | (37.7981407640584, -122.421950099682) | 13 | 9 | 10 | 28858 | 32 | ||||
| 54114 | 140372 | DPW Maintained 1 | :: 45 | 1770 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6002814.2684 | 2113417.5886 | 37.7832006898016 | -122.433953145391 | (37.7832006898016, -122.433953145391) | 13 | 9 | 11 | 29490 | 41 | |||
| 55119 | 43025 | Permitted Site 7 | :: 45 | 430 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42886 | 6004125.6708626 | 2110297.9605007 | 37.774709297051 | -122.429193705112 | (37.774709297051, -122.429193705112) | 7 | 9 | 11 | 28852 | 10 | ||
| 55485 | 138988 | DPW Maintained 1 | :: 45 | 661 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003478.1301 | 2110687.6732 | 37.7757426734052 | -122.431461505307 | (37.7757426734052, -122.431461505307) | 15 | 9 | 11 | 29492 | 10 | |||
| 55750 | 143238 | DPW Maintained 1 | :: 45 | 1734 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004092.1528 | 2119775.7189 | 37.8007309359716 | -122.429985874998 | (37.8007309359716, -122.429985874998) | 13 | 9 | 1 | 57 | 17 | |||
| 56366 | 140554 | DPW Maintained 1 | :: 45 | 830 FULTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003715.6997 | 2111462.8271 | 37.7778845161396 | -122.430695019971 | (37.7778845161396, -122.430695019971) | 15 | 9 | 11 | 29492 | 41 | |||
| 57150 | 10247 | DPW Maintained 1 | :: 45 | 112 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/1997 12:00:00 AM | 8 | 3X3 | 6005536.2501 | 2109637.4907 | 37.7729755585516 | -122.424267236647 | (37.7729755585516, -122.424267236647) | 7 | 9 | 11 | 28852 | 10 | ||
| 57155 | 228475 | DPW Maintained 1 | :: 45 | 214 Haight St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004951.6216 | 2109548.73886 | 37.772698838907 | -122.426283219097 | (37.772698838907, -122.426283219097) | 7 | 9 | 11 | 28852 | 10 | |||
| 66626 | 30705 | Permitted Site 7 | :: 45 | 371 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34615 | 6005225.74804899 | 2110232.43831944 | 37.7745916029272 | -122.425383648395 | (37.7745916029272, -122.425383648395) | 7 | 9 | 11 | 28852 | 10 | ||
| 66707 | 244491 | DPW Maintained 1 | :: 45 | 442 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/28/2011 12:00:00 AM | 2 | Width 0ft | 6004006.3051 | 2109418.5142 | 37.7722877948852 | -122.429543882592 | (37.7722877948852, -122.429543882592) | 7 | 9 | 11 | 29492 | 10 | ||
| 67891 | 255961 | Permitted Site 7 | :: 45 | 2518 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 08/08/2018 12:00:00 AM | 3 | 5x7 | 6003674.59495 | 2116996.308 | 37.7930757331753 | -122.431232293197 | (37.7930757331753, -122.431232293197) | 13 | 9 | 1 | 29490 | 27 | ||
| 69404 | 244492 | DPW Maintained 1 | :: 45 | 456 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/02/2009 12:00:00 AM | 2 | Width 0ft | 6003951.2344 | 2109410.9782 | 37.7722639846023 | -122.429733839468 | (37.7722639846023, -122.429733839468) | 7 | 9 | 11 | 29492 | 10 | ||
| 71605 | 109344 | DPW Maintained 1 | :: 45 | 3211 Baker St | 3 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 02/11/2015 12:00:00 AM | 3 | 4x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | 13 | 9 | 1 | 57 | 17 | ||
| 72005 | 139288 | DPW Maintained 1 | :: 45 | 850 STEINER ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6003023.9373 | 2111228.5503 | 37.7772020350349 | -122.433071323703 | (37.7772020350349, -122.433071323703) | 15 | 9 | 11 | 29492 | 10 | |||
| 72367 | 141411 | DPW Maintained 1 | :: 45 | 530 IVY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004748.0909 | 2111070.6139 | 37.776866029845 | -122.427095672306 | (37.776866029845, -122.427095672306) | 7 | 9 | 11 | 28852 | 10 | |||
| 73450 | 244942 | DPW Maintained 1 | :: 45 | 200 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005544.3019 | 2109980.4712 | 37.7739177547615 | -122.424263782503 | (37.7739177547615, -122.424263782503) | 7 | 9 | 11 | 28852 | 10 | |||
| 74057 | 140195 | DPW Maintained 1 | :: 45 | 801 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6003913.9155 | 2111095.4696 | 37.7768870709162 | -122.429983110687 | (37.7768870709162, -122.429983110687) | 7 | 9 | 11 | 29492 | 10 | |||
| 75459 | 105084 | Significant Tree 6 | :: 45 | 344 Fulton St | 4 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
| 76428 | 244138 | DPW Maintained 1 | :: 45 | 398 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004318.4145 | 2109467.7034 | 37.7724405231997 | -122.428467774696 | (37.7724405231997, -122.428467774696) | 7 | 9 | 11 | 28852 | 10 | |||
| 77535 | 142228 | DPW Maintained 1 | :: 45 | 550 LINDEN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004723.2776 | 2110721.388 | 37.7759057378537 | -122.42715662811 | (37.7759057378537, -122.42715662811) | 7 | 9 | 11 | 28852 | 10 | |||
| 78109 | 140560 | DPW Maintained 1 | :: 45 | 50 FRIENDSHIP CT | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003697.433 | 2111711.0566 | 37.7785650579038 | -122.430775929681 | (37.7785650579038, -122.430775929681) | 15 | 9 | 11 | 29492 | 41 | |||
| 79210 | 109345 | DPW Maintained 1 | :: 45 | 3211 Baker St | 4 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 02/11/2015 12:00:00 AM | 3 | 8.75x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | 13 | 9 | 1 | 57 | 17 | ||
| 79402 | 141945 | DPW Maintained 1 | :: 45 | 1101 GOLDEN GATE AVE | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004212.2215 | 2112170.9783 | 37.7798570416861 | -122.429027879664 | (37.7798570416861, -122.429027879664) | 7 | 9 | 11 | 29490 | 41 | |||
| 79764 | 141421 | DPW Maintained 1 | :: 45 | 550 IVY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004561.2684 | 2111044.0972 | 37.7767826552211 | -122.427740058355 | (37.7767826552211, -122.427740058355) | 7 | 9 | 11 | 28852 | 10 | |||
| 79912 | 254090 | DPW Maintained 1 | :: 45 | 2520 Broadway | 3 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/22/2017 12:00:00 AM | 3 | 1.75x4.9 | 6001556.59478 | 2117325.5311 | 37.7938594403451 | -122.438584281493 | (37.7938594403451, -122.438584281493) | 13 | 9 | 1 | 57 | 27 | ||
| 80835 | 10233 | DPW Maintained 1 | :: 45 | 20 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005984.609 | 2109698.904 | 37.77316949126 | -122.422720671561 | (37.77316949126, -122.422720671561) | 7 | 9 | 11 | 28852 | 10 | |||
| 82350 | 7876 | DPW Maintained 1 | :: 45 | 1095X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/04/2011 12:00:00 AM | 3 | 3x3 | 6006012.62101 | 2113826.37447 | 37.7845041008944 | -122.422917178661 | (37.7845041008944, -122.422917178661) | 7 | 9 | 11 | 28858 | 41 | ||
| 82433 | 109343 | DPW Maintained 1 | :: 45 | 3211 Baker St | 2 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 02/11/2015 12:00:00 AM | 3 | 4x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | 13 | 9 | 1 | 57 | 17 | ||
| 86667 | 43021 | Permitted Site 7 | :: 45 | 537 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42882 | 6003129.08838274 | 2110095.37711913 | 37.7740965863099 | -122.432626609315 | (37.7740965863099, -122.432626609315) | 15 | 9 | 11 | 29492 | 10 | |||
| 87032 | 137836 | DPW Maintained 1 | :: 45 | 2275 CALIFORNIA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003502.6074 | 2115546.0928 | 37.7890840639569 | -122.431723790267 | (37.7890840639569, -122.431723790267) | 13 | 9 | 1 | 29490 | 27 | |||
| 88682 | 108989 | Undocumented 4 | :: 45 | 2073-2099X Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999311.1 | 2121145.9 | 37.8042211586385 | -122.446628874501 | (37.8042211586385, -122.446628874501) | 13 | 9 | 1 | 57 | 17 | |||||
| 91093 | 105091 | Significant Tree 6 | :: 45 | 344 Fulton St | 11 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
| 93102 | 139926 | DPW Maintained 1 | :: 45 | 1001 TURK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005215.378 | 2112666.1069 | 37.7812732756423 | -122.425592763682 | (37.7812732756423, -122.425592763682) | 7 | 9 | 11 | 28852 | 41 | |||
| 94117 | 139809 | DPW Maintained 1 | :: 45 | 1101 GOUGH ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005660.0139 | 2112868.3262 | 37.7818536339515 | -122.424068925498 | (37.7818536339515, -122.424068925498) | 7 | 9 | 11 | 28852 | 41 | |||
| 94170 | 139765 | DPW Maintained 1 | :: 45 | 1306 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004663.7345 | 2113397.522 | 37.7832503745299 | -122.427553303818 | (37.7832503745299, -122.427553303818) | 7 | 9 | 11 | 28858 | 41 | |||
| 94636 | 139766 | DPW Maintained 1 | :: 45 | 1308 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004662.1567 | 2113418.8231 | 37.7833087728144 | -122.427560280444 | (37.7833087728144, -122.427560280444) | 7 | 9 | 11 | 28858 | 41 | |||
| 95197 | 10300 | DPW Maintained 1 | :: 45 | 548 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6003485.1293 | 2109346.6257 | 37.772060883831 | -122.43134154303 | (37.772060883831, -122.43134154303) | 15 | 9 | 11 | 29492 | 10 | |||
| 96905 | 139987 | DPW Maintained 1 | :: 45 | 420 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005805.8873 | 2111752.6705 | 37.7787985511404 | -122.423484930759 | (37.7787985511404, -122.423484930759) | 7 | 9 | 11 | 28852 | 41 | |||
| 100081 | 138003 | DPW Maintained 1 | :: 45 | 1670 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004492.797 | 2114606.7181 | 37.7865608551259 | -122.428230885205 | (37.7865608551259, -122.428230885205) | 13 | 9 | 11 | 28858 | 13 | |||
| 100085 | 141426 | DPW Maintained 1 | :: 45 | 305 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005885.4207 | 2110859.7551 | 37.776351311196 | -122.423146307153 | (37.776351311196, -122.423146307153) | 7 | 9 | 11 | 28852 | 10 | |||
| 102598 | 141857 | DPW Maintained 1 | :: 45 | 1100 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004651.3626 | 2112630.8889 | 37.7811446903449 | -122.427541470502 | (37.7811446903449, -122.427541470502) | 7 | 9 | 11 | 29490 | 41 | |||
| 103616 | 138089 | Undocumented 4 | :: 45 | 1600 SUTTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6004809.7961 | 2114741.3813 | 37.7869485378128 | -122.427143741054 | (37.7869485378128, -122.427143741054) | 13 | 9 | 11 | 28858 | 27 | ||||
| 103987 | 121044 | Undocumented 4 | :: 45 | 2300 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006372 | 2118729 | 37.7979857614387 | -122.422022245981 | (37.7979857614387, -122.422022245981) | 13 | 9 | 10 | 28858 | 32 |
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) );