trees
194 rows where Supervisor Districts = 1 and qSpecies_id = 53 sorted by qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3916 | 261241 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 840 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2020 12:00:00 AM | 3 | Width 4ft | 5985843 | 2115056 | 37.786721565729 | -122.492786794237 | (37.786721565729, -122.492786794237) | 11 | 6 | 1 | 55 | 33 | ||
6921 | 95036 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
11744 | 56147 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2311 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/1973 12:00:00 AM | 16 | Permit Number 12254 | 6001277.58181 | 2116437.20889 | 37.7914044631939 | -122.439485981699 | (37.7914044631939, -122.439485981699) | 13 | 6 | 1 | 29490 | 27 | ||
11986 | 95043 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 4 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 9 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | |||
16842 | 261242 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 840 El Camino Del Mar | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2020 12:00:00 AM | 3 | Width 4ft | 5985843 | 2115056 | 37.786721565729 | -122.492786794237 | (37.786721565729, -122.492786794237) | 11 | 6 | 1 | 55 | 33 | ||
16922 | 59787 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1755 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1981 12:00:00 AM | Permit Number 19237 | 6004552.42886001 | 2119092.68520918 | 37.7988815571833 | -122.428344419585 | (37.7988815571833, -122.428344419585) | 13 | 9 | 1 | 57 | 17 | ||
23488 | 1442 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 144 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 5995540.31731 | 2115189.6989 | 37.7876509503315 | -122.459246293031 | (37.7876509503315, -122.459246293031) | 11 | 6 | 1 | 54 | 31 | |||
26003 | 20242 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1801X Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002529.5506914 | 2114404.1561918 | 37.7858933925245 | -122.435008734319 | (37.7858933925245, -122.435008734319) | 13 | 9 | 1 | 29490 | 27 | |||
28409 | 23540 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2750 Van Ness Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005743.06666 | 2119831.60651 | 37.8009777467475 | -122.424276999326 | (37.8009777467475, -122.424276999326) | 13 | 9 | 1 | 28858 | 32 | |||
28739 | 11129 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2140 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6007198.4118085 | 2119638.2581616 | 37.8005289300711 | -122.419227150729 | (37.8005289300711, -122.419227150729) | 5 | 1 | 1 | 28858 | 32 | |||
34974 | 253521 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2626 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 6006643 | 2120264 | 37.8022157634914 | -122.42119356192 | (37.8022157634914, -122.42119356192) | 5 | 1 | 1 | 28858 | 32 | ||
36964 | 11109 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2022 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X3 | 6007225.09879 | 2119363.63368 | 37.7997763833106 | -122.419115312272 | (37.7997763833106, -122.419115312272) | 5 | 1 | 1 | 28858 | 32 | |||
37162 | 18698 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 251X Richardson Ave | 5 | Median : Cutout | Tree | DPW 1 | 12 | 100 | 5999064.164064 | 2119841.396854 | 37.8006252370733 | -122.447389461083 | (37.8006252370733, -122.447389461083) | 13 | 9 | 1 | 57 | 17 | |||
38327 | 17368 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2308X Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005067.32521 | 2117488.78546 | 37.794506778582 | -122.426448444628 | (37.794506778582, -122.426448444628) | 13 | 9 | 1 | 28858 | 27 | |||
39319 | 23703 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2119X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005103.6033 | 2116867.23334 | 37.7928022043515 | -122.426278644375 | (37.7928022043515, -122.426278644375) | 13 | 9 | 1 | 28858 | 27 | |||
40606 | 18940 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2770 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6001564.88968 | 2115697.48907 | 37.7893897308811 | -122.438438883241 | (37.7893897308811, -122.438438883241) | 13 | 6 | 1 | 29490 | 27 | |||
41017 | 11117 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2054 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6007235.1189832 | 2119374.3616564 | 37.7998064039059 | -122.419081399975 | (37.7998064039059, -122.419081399975) | 5 | 1 | 1 | 28858 | 32 | |||
43653 | 95034 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
49311 | 8762 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3360 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | 11 | 6 | 1 | 54 | 31 | |||
50801 | 95033 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
50984 | 95035 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
55002 | 13200 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2130X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6002179.06604 | 2119515.41872 | 37.7999076905723 | -122.436587295662 | (37.7999076905723, -122.436587295662) | 13 | 9 | 1 | 57 | 17 | |||
55261 | 11108 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2022 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007226.47271 | 2119353.11491 | 37.799747578786 | -122.419109811467 | (37.799747578786, -122.419109811467) | 5 | 1 | 1 | 28858 | 32 | |||
55528 | 23492 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2510 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005839.2618 | 2119053.89467 | 37.7988477792821 | -122.423888789861 | (37.7988477792821, -122.423888789861) | 13 | 9 | 1 | 28858 | 32 | |||
57729 | 16813 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2097X O'Farrell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5999009.37837 | 2112716.355 | 37.7810586242256 | -122.447066002739 | (37.7810586242256, -122.447066002739) | 15 | 5 | 1 | 54 | 16 | |||
57812 | 13193 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2095 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002451.4681 | 2119463.3271 | 37.7997801365268 | -122.435640954547 | (37.7997801365268, -122.435640954547) | 13 | 9 | 1 | 57 | 17 | |||
58920 | 11130 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2140 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6007198.4118085 | 2119638.2581616 | 37.8005289300711 | -122.419227150729 | (37.8005289300711, -122.419227150729) | 5 | 1 | 1 | 28858 | 32 | |||
59694 | 127215 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 4 | Front Yard : Yard | Tree | Private 2 | 8 | Width 4ft | Permit Number 782825 | 5999937.99418 | 2117121.61309 | 37.7932073277938 | -122.44417011406 | (37.7932073277938, -122.44417011406) | 13 | 9 | 1 | 57 | 27 | ||
60447 | 20241 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1801X Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002529.5506914 | 2114404.1561918 | 37.7858933925245 | -122.435008734319 | (37.7858933925245, -122.435008734319) | 13 | 9 | 1 | 29490 | 27 | |||
62202 | 23539 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2750 Van Ness Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | 3x3 | 6005738.98285 | 2119846.6704 | 37.8010188777475 | -122.424292203059 | (37.8010188777475, -122.424292203059) | 13 | 9 | 1 | 28858 | 32 | |||
63549 | 18006 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2700X Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001006.5406952 | 2114902.0443839 | 37.7871738702805 | -122.440313633737 | (37.7871738702805, -122.440313633737) | 13 | 6 | 1 | 29490 | 27 | |||
65216 | 23529 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2750 Van Ness Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005762.85494 | 2119704.71005 | 37.8006304387912 | -122.42419949344 | (37.8006304387912, -122.42419949344) | 13 | 9 | 1 | 28858 | 32 | |||
65259 | 105658 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 901X Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6007813.03508 | 2120272.88823 | 37.8023060594642 | -122.417145293832 | (37.8023060594642, -122.417145293832) | 5 | 1 | 1 | 308 | 32 | ||||
69533 | 8763 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3360 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | 11 | 6 | 1 | 54 | 31 | |||
70974 | 23955 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1985X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6002890.93346 | 2119517.51166 | 37.7999538645084 | -122.434124118866 | (37.7999538645084, -122.434124118866) | 13 | 9 | 1 | 57 | 17 | |||
75386 | 23542 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2750 Van Ness Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6005753.45253 | 2119744.59142 | 37.8007394119615 | -122.424234867659 | (37.8007394119615, -122.424234867659) | 13 | 9 | 1 | 28858 | 32 | |||
76207 | 127218 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 7 | Front Yard : Yard | Tree | Private 2 | 8 | Width 4ft | Permit Number 782825 | 5999923.49955 | 2117118.25276 | 37.7931972742965 | -122.44422002466 | (37.7931972742965, -122.44422002466) | 13 | 9 | 1 | 57 | 27 | ||
77560 | 95038 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
77688 | 1668 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2679X LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 5999625 | 2119128 | 37.7986984723422 | -122.445397421769 | (37.7986984723422, -122.445397421769) | 13 | 9 | 1 | 57 | 17 | |||
77847 | 13285 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2576 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 3 | 3X3 | 6000068.81033 | 2119230.46658 | 37.799005143246 | -122.443869066799 | (37.799005143246, -122.443869066799) | 13 | 9 | 1 | 57 | 17 | ||
77904 | 56931 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1909 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 17 | Permit Number 14175 | 6004317.92538 | 2118019.69798 | 37.795922137343 | -122.429079333669 | (37.795922137343, -122.429079333669) | 13 | 9 | 1 | 28858 | 27 | ||
77923 | 256355 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6005985 | 2121074 | 37.804402699388 | -122.423528183462 | (37.804402699388, -122.423528183462) | 5 | 1 | 1 | 28858 | 32 | |||
79887 | 16728 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1519 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 5999136.4110982 | 2112734.4359693 | 37.7811155269813 | -122.446627836224 | (37.7811155269813, -122.446627836224) | 15 | 5 | 1 | 54 | 16 | |||
87780 | 95040 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 13 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
91802 | 8767 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3360 Geary Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | 11 | 6 | 1 | 54 | 31 | |||
98303 | 23537 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2750 Van Ness Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6005731.47426 | 2119901.45589 | 37.8011688807257 | -122.424322084799 | (37.8011688807257, -122.424322084799) | 13 | 9 | 1 | 28858 | 32 | |||
105287 | 18158 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1380X Post St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005557.7830834 | 2114491.983444 | 37.7863060232386 | -122.424538126694 | (37.7863060232386, -122.424538126694) | 13 | 9 | 1 | 28858 | 41 | |||
107261 | 18696 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 251X Richardson Ave | 3 | Median : Cutout | Tree | DPW 1 | 12 | 100 | 5999064.164064 | 2119841.396854 | 37.8006252370733 | -122.447389461083 | (37.8006252370733, -122.447389461083) | 13 | 9 | 1 | 57 | 17 | |||
109441 | 127217 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 6 | Front Yard : Yard | Tree | Private 2 | 7 | Width 4ft | Permit Number 782825 | 5999928.92975 | 2117120.95639 | 37.7932050075467 | -122.444201430254 | (37.7932050075467, -122.444201430254) | 13 | 9 | 1 | 57 | 27 | ||
111411 | 253520 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2626 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 6006643 | 2120264 | 37.8022157634914 | -122.42119356192 | (37.8022157634914, -122.42119356192) | 5 | 1 | 1 | 28858 | 32 | ||
115585 | 13186 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2051X Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002574.7502816 | 2119473.5963948 | 37.7998153348368 | -122.435215088035 | (37.7998153348368, -122.435215088035) | 13 | 9 | 1 | 57 | 17 | |||
120455 | 1669 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2679X LOMBARD ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 3X3 | 5999625 | 2119128 | 37.7986984723422 | -122.445397421769 | (37.7986984723422, -122.445397421769) | 13 | 9 | 1 | 57 | 17 | |||
120658 | 13201 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2130X Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6002179.06604 | 2119515.41872 | 37.7999076905723 | -122.436587295662 | (37.7999076905723, -122.436587295662) | 13 | 9 | 1 | 57 | 17 | |||
120727 | 27489 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2109 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6005954.70257 | 2117589.1006 | 37.7948323414476 | -122.42338513917 | (37.7948323414476, -122.42338513917) | 13 | 9 | 1 | 28858 | 27 | |||
120981 | 95046 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 10 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 13 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | |||
122122 | 127204 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 46 Presidio Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781066 | 5998981 | 2116428 | 37.7912482078936 | -122.447431413946 | (37.7912482078936, -122.447431413946) | 13 | 6 | 1 | 29490 | 31 | |
122270 | 95039 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
125597 | 7374 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2498 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5x5 | 6002741.92214 | 2116738.58592 | 37.7923151963696 | -122.43444095639 | (37.7923151963696, -122.43444095639) | 13 | 9 | 1 | 29490 | 27 | |||
129349 | 95041 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
134352 | 18684 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 165X Richardson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5999250.42609 | 2119592.62258 | 37.7999528116563 | -122.446727010779 | (37.7999528116563, -122.446727010779) | 13 | 9 | 1 | 57 | 17 | |||
134927 | 23538 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2750 Van Ness Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 3x3 | 6005735.64624 | 2119861.71432 | 37.8010599961041 | -122.424304819753 | (37.8010599961041, -122.424304819753) | 13 | 9 | 1 | 28858 | 32 | |||
135783 | 13192 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2095 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002431.86629 | 2119459.61132 | 37.7997688205881 | -122.435708517981 | (37.7997688205881, -122.435708517981) | 13 | 9 | 1 | 57 | 17 | |||
137263 | 27617 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2512 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002699.61445 | 2115865.03401 | 37.7899142453613 | -122.434524853763 | (37.7899142453613, -122.434524853763) | 13 | 9 | 1 | 29490 | 27 | |||
141424 | 95044 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 6 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
142881 | 95042 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 2 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 11 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | |||
147341 | 127216 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 5 | Front Yard : Yard | Tree | Private 2 | 8 | Width 4ft | Permit Number 782825 | 5999932.8876 | 2117120.87416 | 37.7932050075595 | -122.444187729973 | (37.7932050075595, -122.444187729973) | 13 | 9 | 1 | 57 | 27 | ||
152976 | 17360 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2298X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3X3 | 6005094.42253 | 2117295.11988 | 37.7939765536908 | -122.426340889125 | (37.7939765536908, -122.426340889125) | 13 | 9 | 1 | 28858 | 27 | |||
155737 | 117286 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3500 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6002513 | 2120207 | 37.8018255621759 | -122.435481260672 | (37.8018255621759, -122.435481260672) | 13 | 9 | 1 | 57 | 17 | ||||
157941 | 8764 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3360 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | 11 | 6 | 1 | 54 | 31 | |||
158341 | 1760 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3041X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6005500.29496 | 2120778.87447 | 37.8035649903432 | -122.425184535531 | (37.8035649903432, -122.425184535531) | 13 | 9 | 1 | 28858 | 17 | |||
161646 | 8766 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3360 Geary Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | 11 | 6 | 1 | 54 | 31 | |||
163000 | 20243 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1801X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002529.5506914 | 2114404.1561918 | 37.7858933925245 | -122.435008734319 | (37.7858933925245, -122.435008734319) | 13 | 9 | 1 | 29490 | 27 | |||
164308 | 18035 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2807 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000503.4629009 | 2114781.5023211 | 37.7868142369045 | -122.442045513134 | (37.7868142369045, -122.442045513134) | 13 | 6 | 1 | 29490 | 27 | |||
165633 | 23541 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2750 Van Ness Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6005750.94301 | 2119762.60418 | 37.8007887287045 | -122.42424483346 | (37.8007887287045, -122.42424483346) | 13 | 9 | 1 | 28858 | 32 | |||
171543 | 18697 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 251X Richardson Ave | 4 | Median : Cutout | Tree | DPW 1 | 12 | 100 | 5999064.164064 | 2119841.396854 | 37.8006252370733 | -122.447389461083 | (37.8006252370733, -122.447389461083) | 13 | 9 | 1 | 57 | 17 | |||
176898 | 8765 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3360 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | 11 | 6 | 1 | 54 | 31 | |||
177292 | 16729 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1519 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5999136.4110982 | 2112734.4359693 | 37.7811155269813 | -122.446627836224 | (37.7811155269813, -122.446627836224) | 15 | 5 | 1 | 54 | 16 | |||
179087 | 105657 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 901X Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6007813.03508 | 2120272.88823 | 37.8023060594642 | -122.417145293832 | (37.8023060594642, -122.417145293832) | 5 | 1 | 1 | 308 | 32 | ||||
179910 | 27490 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2107 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6005886.29279 | 2117665.93165 | 37.7950394389183 | -122.42362731207 | (37.7950394389183, -122.42362731207) | 13 | 9 | 1 | 28858 | 27 | |||
182487 | 256357 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6005985 | 2121074 | 37.804402699388 | -122.423528183462 | (37.804402699388, -122.423528183462) | 5 | 1 | 1 | 28858 | 32 | |||
183120 | 17367 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2308X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005067.32521 | 2117488.78546 | 37.794506778582 | -122.426448444628 | (37.794506778582, -122.426448444628) | 13 | 9 | 1 | 28858 | 27 | |||
184073 | 8768 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3360 Geary Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | 11 | 6 | 1 | 54 | 31 | |||
184158 | 127219 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 8 | Front Yard : Yard | Tree | Private 2 | 8 | Width 4ft | Permit Number 782825 | 5999916.98549 | 2117117.82475 | 37.7931957274607 | -122.444242532876 | (37.7931957274607, -122.444242532876) | 13 | 9 | 1 | 57 | 27 | ||
184329 | 173906 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2510 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6005854.79213 | 2118988.36383 | 37.7986687249765 | -122.423830387644 | (37.7986687249765, -122.423830387644) | 13 | 9 | 1 | 28858 | 32 | |||||
184916 | 20245 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1823 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/13/1989 12:00:00 AM | 12 | 3X3 | 6002519.5885419 | 2114476.0123893 | 37.7860901257054 | -122.435048341611 | (37.7860901257054, -122.435048341611) | 13 | 9 | 1 | 29490 | 27 | ||
184950 | 18016 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2714 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000941.6382972 | 2114893.0059573 | 37.7871453575959 | -122.440537532879 | (37.7871453575959, -122.440537532879) | 13 | 6 | 1 | 29490 | 27 | |||
186277 | 13199 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2130X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6002179.06604 | 2119515.41872 | 37.7999076905723 | -122.436587295662 | (37.7999076905723, -122.436587295662) | 13 | 9 | 1 | 57 | 17 | |||
192030 | 256356 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6005985 | 2121074 | 37.804402699388 | -122.423528183462 | (37.804402699388, -122.423528183462) | 5 | 1 | 1 | 28858 | 32 | |||
193344 | 13225 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2265 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001602.67751 | 2119341.9386 | 37.799398588794 | -122.438569375951 | (37.799398588794, -122.438569375951) | 13 | 9 | 1 | 57 | 17 | |||
117 | 108152 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2232 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003295.44003 | 2116396.66877 | 37.7914077834913 | -122.432501340527 | (37.7914077834913, -122.432501340527) | 13 | 9 | 1 | 29490 | 27 | |||||
2653 | 100053 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 13 | 9 | 1 | 57 | 17 | |||
11207 | 108105 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2390X Green St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | 13 | 9 | 1 | 57 | 17 | |||||
14328 | 104230 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 409 Walnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14x8 | 5998587.6 | 2115205.6 | 37.787869332154 | -122.448704479556 | (37.787869332154, -122.448704479556) | 13 | 6 | 1 | 54 | 31 | ||||
21498 | 98979 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 38 MILEY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 778225 | 5999656 | 2118689 | 37.7974948649915 | -122.4452585722 | (37.7974948649915, -122.4452585722) | 13 | 9 | 1 | 57 | 17 | ||
38651 | 113775 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1712 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6000121 | 2114885 | 37.7870766118482 | -122.443376178084 | (37.7870766118482, -122.443376178084) | 13 | 6 | 1 | 29490 | 27 | |||
39370 | 107630 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2164 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6001495 | 2119755 | 37.8005266206576 | -122.438971595662 | (37.8005266206576, -122.438971595662) | 13 | 9 | 1 | 57 | 17 | |||
47028 | 110967 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2439 WASHINGTON ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003043 | 2116458 | 37.7915618650441 | -122.433379161821 | (37.7915618650441, -122.433379161821) | 13 | 9 | 1 | 29490 | 27 | ||||
48110 | 108103 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2390X Green St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | 13 | 9 | 1 | 57 | 17 | |||||
48222 | 100107 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 461 Jefferson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007004.8 | 2122229.7 | 37.8076334645768 | -122.420081138169 | (37.8076334645768, -122.420081138169) | 5 | 1 | 1 | 308 | 32 | |||||
48350 | 111430 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500X PRESIDIO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999200 | 2114887 | 37.7870295394193 | -122.446562765799 | (37.7870295394193, -122.446562765799) | 15 | 6 | 1 | 29490 | 31 |
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) );