trees
1,408 rows where qSpecies_id = 113 sorted by qCaretaker_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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3905 | 19979 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 STAIRWAY45 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 30ST | |||||||||||||
5147 | 19819 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 STAIRWAY25 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
5627 | 19964 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 STAIRWAY41 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
9556 | 19963 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 STAIRWAY41 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
11839 | 19962 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 STAIRWAY41 | -2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
13545 | 129348 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1306x Montgomery St | 33 | Median : Yard | Tree | DPW 1 | 2 | Width 8ft | 6011427.80927 | 2120135.82348 | 37.802132403051 | -122.404626688974 | (37.802132403051, -122.404626688974) | 3 | 1 | 10 | 308 | 23 | |||
13953 | 116804 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 131 LAKESHORE DR | 1 | Median : Yard | Landscaping | DPW 1 | 10x100 | 5984782 | 2094243 | 37.7295127607338 | -122.494922366174 | (37.7295127607338, -122.494922366174) | 1 | 8 | 4 | 64 | 35 | ||||
17035 | 866 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 600X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1X1 | 6007241.9784 | 2095034.86963 | 37.7329762592527 | -122.417331878084 | (37.7329762592527, -122.417331878084) | 2 | 7 | 7 | 28859 | 2 | |||
17115 | 129350 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1306x Montgomery St | 38 | Median : Yard | Tree | DPW 1 | 1 | Width 8ft | 6011425.50986 | 2120159.17711 | 37.8021963979046 | -122.404636291051 | (37.8021963979046, -122.404636291051) | 3 | 1 | 10 | 308 | 23 | |||
43581 | 16098 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 300 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/17/1997 12:00:00 AM | 6 | 2X3 | 6000050.52204 | 2094718.8331 | 37.7317012658005 | -122.442171864536 | (37.7317012658005, -122.442171864536) | 9 | 7 | 4 | 63 | 40 | ||
47374 | 190817 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 390x Hampshire St | 5 | Median : Cutout | Tree | DPW 1 | 13 | Width 5ft | 6010044.56493 | 2106488.02831 | 37.7645813917285 | -122.408450158441 | (37.7645813917285, -122.408450158441) | 8 | 4 | 8 | 28853 | 19 | |||
51023 | 190814 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 390x Hampshire St | 1 | Median : Cutout | Tree | DPW 1 | 16 | Width 5ft | 6010041.11906 | 2106539.02685 | 37.7647212291204 | -122.408465674446 | (37.7647212291204, -122.408465674446) | 8 | 4 | 8 | 28853 | 19 | |||
58406 | 19313 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 21 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5993901.63447 | 2089816.98545 | 37.7178896324771 | -122.463074115289 | (37.7178896324771, -122.463074115289) | 9 | 8 | 6 | 64 | 24 | |||
59655 | 16099 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 300 Monterey Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000036.69943 | 2094718.89433 | 37.7317006461483 | -122.442219656332 | (37.7317006461483, -122.442219656332) | 9 | 7 | 4 | 63 | 40 | |||
73504 | 1100 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2328 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5999423.31284 | 2089282.14336 | 37.7167376054458 | -122.443949765773 | (37.7167376054458, -122.443949765773) | 9 | 7 | 6 | 28861 | 25 | |||
74370 | 121732 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1301 Vermont St | 7 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
81841 | 107491 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1306x Montgomery St | 20 | Median : Cutout | Tree | DPW 1 | 8 | 6011446.04828 | 2119975.74616 | 37.8016938891322 | -122.40455229795 | (37.8016938891322, -122.40455229795) | 3 | 1 | 10 | 308 | 23 | ||||
85055 | 16377 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1400X Montgomery St | 10 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6011455.2971485 | 2120087.0441833 | 37.8020000032358 | -122.404528131508 | (37.8020000032358, -122.404528131508) | 3 | 1 | 10 | 308 | 23 | |||
94738 | 16410 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1186X Munich St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | TR | 6001066.26402 | 2087197.59203 | 37.7111074743937 | -122.438121667875 | (37.7111074743937, -122.438121667875) | 9 | 7 | 6 | 28861 | 5 | |||
100239 | 190816 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 390x Hampshire St | 3 | Median : Cutout | Tree | DPW 1 | 7 | Width 5ft | 6010044.10542 | 2106509.48106 | 37.7646402703573 | -122.408453261111 | (37.7646402703573, -122.408453261111) | 8 | 4 | 8 | 28853 | 19 | |||
108970 | 129353 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1306x Montgomery St | 51 | Median : Yard | Tree | DPW 1 | 6 | Width 8ft | 6011391.40683 | 2120329.06369 | 37.8026609588854 | -122.404766271855 | (37.8026609588854, -122.404766271855) | 3 | 1 | 10 | 308 | 23 | |||
113738 | 5821 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1027 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 75 | 3X3 | 5999811.0829915 | 2099731.7400522 | 37.745451872839 | -122.443359584044 | (37.745451872839, -122.443359584044) | 2 | 7 | 5 | 63 | 22 | |||
113827 | 16102 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 300 Monterey Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000017.68556 | 2094719.96601 | 37.7317025050652 | -122.442285467815 | (37.7317025050652, -122.442285467815) | 9 | 7 | 4 | 63 | 40 | |||
123493 | 121734 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1301 Vermont St | 9 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
128308 | 25938 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2000 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/1997 12:00:00 AM | 12 | 3x3 | 6012867.3394 | 2097145.55731 | 37.7390866585199 | -122.398031427109 | (37.7390866585199, -122.398031427109) | 10 | 3 | 8 | 58 | 1 | ||
136033 | 25939 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2000 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/1997 12:00:00 AM | 10 | 3x3 | 6012857.31615 | 2097153.53613 | 37.7391080084261 | -122.398066642772 | (37.7391080084261, -122.398066642772) | 10 | 3 | 8 | 58 | 1 | ||
139770 | 129351 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1306x Montgomery St | 39 | Median : Yard | Tree | DPW 1 | 1 | Width 8ft | 6011425.67929 | 2120161.57643 | 37.8022029953207 | -122.404635873741 | (37.8022029953207, -122.404635873741) | 3 | 1 | 10 | 308 | 23 | |||
143530 | 878 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 600X Alemany Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1X1 | 6007241.9784 | 2095034.86963 | 37.7329762592527 | -122.417331878084 | (37.7329762592527, -122.417331878084) | 2 | 7 | 7 | 28859 | 2 | |||
147393 | 12623 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 825 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 27 | 3X3 | 5992882.168 | 2114794.01241 | 37.7864113245051 | -122.468414093066 | (37.7864113245051, -122.468414093066) | 11 | 6 | 2 | 54 | 11 | |||
147912 | 129352 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1306x Montgomery St | 45 | Median : Yard | Tree | DPW 1 | 3 | Width 8ft | 6011406.69978 | 2120255.02893 | 37.8024585322873 | -122.404708135188 | (37.8024585322873, -122.404708135188) | 3 | 1 | 10 | 308 | 23 | |||
157988 | 16127 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 330 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5999874.93833 | 2094721.12407 | 37.7316975479954 | -122.442779055318 | (37.7316975479954, -122.442779055318) | 9 | 7 | 4 | 63 | 40 | |||
170224 | 16100 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 300 Monterey Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000028.57256 | 2094720.41703 | 37.7317043639536 | -122.442247861742 | (37.7317043639536, -122.442247861742) | 9 | 7 | 4 | 63 | 40 | |||
173378 | 190815 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 390x Hampshire St | 2 | Median : Cutout | Tree | DPW 1 | 11 | Width 5ft | 6010042.68497 | 2106527.82648 | 37.7646905631515 | -122.408459468238 | (37.7646905631515, -122.408459468238) | 8 | 4 | 8 | 28853 | 19 | |||
174770 | 24744 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 128X Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/1996 12:00:00 AM | 3 | 3x3 | 5982380.47142 | 2112632.14331 | 37.7798632908372 | -122.504586464809 | (37.7798632908372, -122.504586464809) | 11 | 6 | 2 | 55 | 26 | ||
180955 | 129354 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1306x Montgomery St | 52 | Median : Yard | Tree | DPW 1 | 14 | Width 8ft | 6011388.89614 | 2120338.61388 | 37.8026870410416 | -122.404775632902 | (37.8026870410416, -122.404775632902) | 3 | 1 | 10 | 308 | 23 | |||
185654 | 219372 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 400x Marietta Dr | 17 | Median : Cutout | Tree | DPW 1 | 9 | Width 3ft | 5999397.86314 | 2097051.08053 | 37.7380678498474 | -122.444595794674 | (37.7380678498474, -122.444595794674) | 9 | 7 | 4 | 59 | 40 | |||
192555 | 129349 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1306x Montgomery St | 35 | Median : Yard | Tree | DPW 1 | 2 | Width 8ft | 6011426.64663 | 2120143.89656 | 37.8021545047788 | -122.404631280934 | (37.8021545047788, -122.404631280934) | 3 | 1 | 10 | 308 | 23 | |||
501 | 108350 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 1501x RIVERA ST | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5988383 | 2100343 | 37.7464719103157 | -122.482920391178 | (37.7464719103157, -122.482920391178) | 1 | 8 | 3 | 29491 | 35 | ||||
1554 | 129221 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2711 Vallejo St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6000567.88231 | 2117494.00338 | 37.7942657282202 | -122.442017408682 | (37.7942657282202, -122.442017408682) | 13 | 9 | 1 | 57 | 27 | |||
1587 | 35594 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1303 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/27/1998 12:00:00 AM | 5 | Permit Number 38957 | 6012015.58746 | 2102213.67536 | 37.7529551460873 | -122.401332479509 | (37.7529551460873, -122.401332479509) | 10 | 3 | 8 | 28856 | 29 | |
1938 | 219404 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 471 Mangels Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5998306.28146 | 2095220.78528 | 37.7329799470492 | -122.448238160486 | (37.7329799470492, -122.448238160486) | 9 | 7 | 4 | 59 | 40 | |||
2123 | 176806 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 102 Bowdoin St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6008418.41029 | 2094548.16492 | 37.7317059917167 | -122.413230227789 | (37.7317059917167, -122.413230227789) | 9 | 3 | 7 | 309 | 28 | |||
2317 | 129136 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2500 Chestnut St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 5999820.13203 | 2119534.7646 | 37.7998264765557 | -122.444751458338 | (37.7998264765557, -122.444751458338) | 13 | 9 | 1 | 57 | 17 | |||
2355 | 176777 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 107 Colby St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6008230.80526 | 2093471.1524 | 37.7287382127949 | -122.413802663375 | (37.7287382127949, -122.413802663375) | 9 | 3 | 7 | 309 | 28 | |||
2389 | 226983 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 115 Farnum St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6002427.40541 | 2097410.1517 | 37.7392261829547 | -122.434146834405 | (37.7392261829547, -122.434146834405) | 2 | 7 | 5 | 63 | 7 | |||
2412 | 219263 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1851 08th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5993725.67794 | 2102905.85054 | 37.7538182676993 | -122.464632221316 | (37.7538182676993, -122.464632221316) | 1 | 8 | 4 | 56 | 12 | |||
2435 | 129307 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2363 Larkin St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 6006689.73885 | 2119362.09742 | 37.7997420023389 | -122.420967750079 | (37.7997420023389, -122.420967750079) | 13 | 9 | 1 | 28858 | 32 | |||
2700 | 176810 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 79 Colby St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6008186.25222 | 2093616.43153 | 37.7291346159515 | -122.413966959633 | (37.7291346159515, -122.413966959633) | 9 | 3 | 7 | 309 | 28 | |||
3385 | 223764 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 126 Bradford St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6009530.67949 | 2097860.55808 | 37.7408634922583 | -122.409618578359 | (37.7408634922583, -122.409618578359) | 10 | 7 | 7 | 28859 | 2 | |||
3474 | 38364 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 4001 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/2002 12:00:00 AM | 5 | Permit Number 44994 | 5981794.8549 | 2104174.5597 | 37.7566067521127 | -122.50598509825 | (37.7566067521127, -122.50598509825) | 1 | 8 | 3 | 56 | 35 | |
3576 | 129155 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 3140 Pacific Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 2ft | 5999111.81461 | 2116653.58178 | 37.7918750703267 | -122.4469950411 | (37.7918750703267, -122.4469950411) | 11 | 6 | 1 | 29490 | 30 | |||
3813 | 176671 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 500x San Juan Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 2ft | 6000440.43474 | 2092860.77254 | 37.7266216745319 | -122.440690633469 | (37.7266216745319, -122.440690633469) | 9 | 7 | 6 | 28861 | 25 | |||
3844 | 54791 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 280 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1972 12:00:00 AM | 18 | Permit Number 10640 | 6012628.37407 | 2087183.5823 | 37.7117197939932 | -122.398158948299 | (37.7117197939932, -122.398158948299) | 10 | 3 | 8 | 309 | 1 | ||
3998 | 176849 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Gambier St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6005708.05423 | 2093517.46622 | 37.7287233829612 | -122.422527275231 | (37.7287233829612, -122.422527275231) | 9 | 7 | 7 | 309 | 5 | |||
4224 | 129241 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2792 Fillmore St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6002607.77018 | 2117744.6226 | 37.7950698975185 | -122.434977106511 | (37.7950698975185, -122.434977106511) | 13 | 9 | 1 | 29490 | 27 | |||
4813 | 223765 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 126 Bradford St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6009530.59471 | 2097856.4038 | 37.7408520807582 | -122.409618578357 | (37.7408520807582, -122.409618578357) | 10 | 7 | 7 | 28859 | 2 | |||
4817 | 219315 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1200 Capitol Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 1ft | 5995096.96866 | 2091948.28525 | 37.7238104576833 | -122.459096640518 | (37.7238104576833, -122.459096640518) | 9 | 8 | 4 | 28861 | 24 | |||
4999 | 118705 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 4225 Balboa St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 5982441.7055 | 2110968.62548 | 37.7752993599927 | -122.504251368027 | (37.7752993599927, -122.504251368027) | 11 | 6 | 2 | 55 | 26 | |||
5471 | 226856 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1706 Dolores St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6005261.02948 | 2098379.01551 | 37.7420468804511 | -122.424418319247 | (37.7420468804511, -122.424418319247) | 2 | 7 | 5 | 63 | 7 | |||
5623 | 226838 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 14 Liberty St | 2 | : | Tree | Private 2 | 7 | Width 1ft | 6006187.25946 | 2104078.53237 | 37.7577487106567 | -122.42162041686 | (37.7577487106567, -122.42162041686) | 2 | 4 | 5 | 28859 | 19 | |||
5788 | 219297 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 381 Flood Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5998167.92855 | 2094066.72164 | 37.7298032511049 | -122.448633390929 | (37.7298032511049, -122.448633390929) | 9 | 7 | 4 | 28861 | 40 | |||
6098 | 129331 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1101 Greenwich St | 9 | Front Yard : Yard | Tree | Private 2 | 2 | 6007561.62509 | 2119863.3782 | 37.8011675015458 | -122.417986250159 | (37.8011675015458, -122.417986250159) | 5 | 1 | 1 | 28858 | 32 | ||||
6243 | 226941 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 300 Fairmount St | 1 | Side Yard : Yard | Tree | Private 2 | 16 | 6004051.37428 | 2097144.63452 | 37.7385891688512 | -122.428512957704 | (37.7385891688512, -122.428512957704) | 2 | 7 | 5 | 63 | 7 | ||||
6362 | 176782 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 101 Dartmouth St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6008503.6919 | 2093600.78461 | 37.7291094763057 | -122.412868435047 | (37.7291094763057, -122.412868435047) | 9 | 3 | 7 | 309 | 28 | |||
6643 | 176656 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 83 Badger St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 2ft | 6002434.052 | 2094281.82238 | 37.7306368857794 | -122.433900305949 | (37.7306368857794, -122.433900305949) | 9 | 7 | 5 | 28861 | 25 | |||
6699 | 123104 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 446 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 5992530.91894 | 2112401.00432 | 37.7798204855095 | -122.469455059019 | (37.7798204855095, -122.469455059019) | 11 | 6 | 2 | 54 | 11 | |||
7280 | 176726 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1835 Silliman St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6005342.6627 | 2092636.32324 | 37.7262833378802 | -122.4237278324 | (37.7262833378802, -122.4237278324) | 9 | 7 | 7 | 309 | 5 | |||
7378 | 219397 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 407 Congo St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6000069.67412 | 2095030.49113 | 37.7325580975702 | -122.442128015408 | (37.7325580975702, -122.442128015408) | 9 | 7 | 4 | 63 | 40 | |||
7528 | 226882 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2810 19th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6009447.14609 | 2105030.4857 | 37.7605458378345 | -122.410413552952 | (37.7605458378345, -122.410413552952) | 2 | 4 | 7 | 28859 | 19 | |||
7930 | 223763 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 126 Bradford St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6009530.79254 | 2097866.09723 | 37.7408787078943 | -122.409618578334 | (37.7408787078943, -122.409618578334) | 10 | 7 | 7 | 28859 | 2 | |||
8403 | 249624 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2450 Golden Gate Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 7ft | 5997651.05189 | 2111322.51448 | 37.7771538015333 | -122.451664533393 | (37.7771538015333, -122.451664533393) | 15 | 6 | 2 | 54 | 16 | |||
8564 | 206953 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 200 Judson Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 5998675.41123 | 2093529.72408 | 37.7283577869787 | -122.446840347823 | (37.7283577869787, -122.446840347823) | 9 | 7 | 4 | 28861 | 40 | |||
8677 | 249743 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2500 Broderick St | 27 | : | Tree | Private 2 | 8 | Width 1ft | 6000230.51867 | 2117262.97292 | 37.7936121486327 | -122.443168120916 | (37.7936121486327, -122.443168120916) | 13 | 9 | 1 | 57 | 27 | |||
8754 | 219312 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 322 Havelock St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 5998687.37843 | 2092940.65981 | 37.7267410379466 | -122.446756609236 | (37.7267410379466, -122.446756609236) | 9 | 7 | 4 | 28861 | 40 | |||
9051 | 176690 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 242 Athens St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6004472.37947 | 2091855.23398 | 37.7240894732252 | -122.426680760821 | (37.7240894732252, -122.426680760821) | 9 | 7 | 6 | 28861 | 5 | ||||
9609 | 129180 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 3298 Lyon St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 5998992.55112 | 2120173.79871 | 37.8015338304744 | -122.447661212108 | (37.8015338304744, -122.447661212108) | 13 | 9 | 1 | 57 | 17 | ||||
9623 | 118669 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 4550 Balboa St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 50 | 5981412.61192 | 2111005.49415 | 37.7753400136649 | -122.507813913091 | (37.7753400136649, -122.507813913091) | 11 | 6 | 2 | 55 | 26 | ||||
9994 | 176783 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 799X Silliman St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6008526 | 2093580 | 37.7290536583746 | -122.412789845037 | (37.7290536583746, -122.412789845037) | 9 | 3 | 7 | 309 | 28 | |||
10469 | 259580 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 398 Public Park | 2 | Unaccepted Street : Cutout | Tree | Private 2 | 3x3 | 5994369 | 2098919 | 37.7429084509163 | -122.462118372119 | (37.7429084509163, -122.462118372119) | 1 | 8 | 4 | 59 | 40 | ||||
10643 | 129149 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1800 Jefferson St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6000512.40261 | 2121367.00013 | 37.8048967868113 | -122.442487569762 | (37.8048967868113, -122.442487569762) | 13 | 9 | 1 | 57 | 17 | |||
10675 | 247554 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 815 Buena Vista Ave West | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | Width 2ft | 6000050.05446 | 2108365.18828 | 37.769170829105 | -122.443153202975 | (37.769170829105, -122.443153202975) | 15 | 5 | 11 | 29492 | 9 | |||
10906 | 190798 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2098 20th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 7ft | 6011929.82719 | 2104699.62352 | 37.7597762277144 | -122.401803784534 | (37.7597762277144, -122.401803784534) | 10 | 3 | 8 | 28856 | 29 | |||
11113 | 107054 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 98X ROTTECK ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | 6003385 | 2094496 | 37.7312788881427 | -122.43062801307 | (37.7312788881427, -122.43062801307) | 9 | 7 | 5 | 28861 | 25 | |||
11114 | 71583 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 266 Flournoy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5993925.4185 | 2086705.15736 | 37.7093466620935 | -122.462766282735 | (37.7093466620935, -122.462766282735) | 9 | 8 | 6 | 28861 | 25 | |||
11541 | 219252 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 493 Joost Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5998807.21011 | 2094945.46348 | 37.7322526032772 | -122.446486525737 | (37.7322526032772, -122.446486525737) | 9 | 7 | 4 | 59 | 40 | |||
11982 | 70512 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 75 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6004917.4216 | 2092965.01921 | 37.7271618505134 | -122.425221249286 | (37.7271618505134, -122.425221249286) | 9 | 7 | 6 | 28861 | 5 | |||
12687 | 219408 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 826 Detroit St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 5999474.92133 | 2095660.53825 | 37.7342541461187 | -122.444229471118 | (37.7342541461187, -122.444229471118) | 9 | 7 | 4 | 63 | 40 | |||
12750 | 201353 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1 Bitting Ave | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012904.00238 | 2092563.8073 | 37.7265081621175 | -122.397583402851 | (37.7265081621175, -122.397583402851) | 10 | 3 | 8 | 58 | 1 | |||
12897 | 61250 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2033 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1987 12:00:00 AM | 7 | Permit Number 24211 | 6007651.97178 | 2119454.00624 | 37.8000485533513 | -122.41764457883 | (37.8000485533513, -122.41764457883) | 5 | 1 | 1 | 28858 | 32 | |
13113 | 129304 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1101 Francisco St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6005981.05441 | 2120675.33174 | 37.8033078358583 | -122.423513477178 | (37.8033078358583, -122.423513477178) | 5 | 9 | 1 | 28858 | 32 | |||
13233 | 219254 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 449 Melrose Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5997174.97013 | 2095514.34446 | 37.7337212492173 | -122.452170552242 | (37.7337212492173, -122.452170552242) | 9 | 7 | 4 | 59 | 40 | ||||
13280 | 226873 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2001 Bryant St | 6 | : | Tree | Private 2 | 7 | Width 3ft | 6009581.91025 | 2105420.85963 | 37.7616252698063 | -122.409975021942 | (37.7616252698063, -122.409975021942) | 2 | 4 | 8 | 28859 | 19 | |||
13459 | 226896 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1243 Valencia St | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 30 | Width 3ft | 6006432.37393 | 2102561.6161 | 37.7535974274886 | -122.420665025691 | (37.7535974274886, -122.420665025691) | 2 | 4 | 7 | 28859 | 19 | |||
14000 | 176632 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 110 Newton St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6000949.95305 | 2087893.72595 | 37.7130122879616 | -122.438573512475 | (37.7130122879616, -122.438573512475) | 9 | 7 | 6 | 28861 | 5 | |||
14065 | 129131 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 3542 Divisadero St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6000280.24975 | 2120491.13146 | 37.8024786510429 | -122.443228011273 | (37.8024786510429, -122.443228011273) | 13 | 9 | 1 | 57 | 17 | |||
14149 | 176803 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 103 Bowdoin St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6008471.38448 | 2094562.18285 | 37.731747455866 | -122.413048075521 | (37.731747455866, -122.413048075521) | 9 | 3 | 7 | 309 | 28 | |||
14336 | 226984 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2323 Diamond St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6001664.11704 | 2096982.04185 | 37.7380073425508 | -122.436755300925 | (37.7380073425508, -122.436755300925) | 2 | 7 | 5 | 63 | 7 | |||
14493 | 258979 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 799X Silliman St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 5ft | 6008526 | 2093580 | 37.7290536583746 | -122.412789845037 | (37.7290536583746, -122.412789845037) | 9 | 3 | 7 | 309 | 28 | ||||
14613 | 129359 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2431 Jones St | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6007962.68527 | 2120698.03177 | 37.8034818141966 | -122.416657564817 | (37.8034818141966, -122.416657564817) | 5 | 1 | 1 | 308 | 32 | |||
14667 | 190808 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2115 22nd St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | Width 2ft | 6011806.38674 | 2103701.05515 | 37.7570274903299 | -122.402160501522 | (37.7570274903299, -122.402160501522) | 10 | 3 | 8 | 28856 | 29 |
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) );