trees
139 rows where qCaretaker_id = 1 and qSpecies_id = 35 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9342 | 23614 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 910X Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 30X30PL | 6011300.2113585 | 2104101.3880723 | 37.7580984495586 | -122.403939228694 | (37.7580984495586, -122.403939228694) | 10 | 3 | 8 | 28856 | 29 | |||
13326 | 258119 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Clarendon Ave | 1 | Median : Cutout | Tree | DPW 1 | 05/26/2019 09:14:00 PM | 3 | 5x5 | ||||||||||||
33534 | 27300 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7900X Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/10/1999 12:00:00 AM | 6 | 5x5 | 5982547.93354 | 2112415.51016 | 37.7792783288562 | -122.503991098801 | (37.7792783288562, -122.503991098801) | 11 | 6 | 2 | 55 | 26 | ||
43150 | 8574 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 6 | 6 | 6001134.4053 | 2113480.979 | 37.7832792690603 | -122.439769329053 | (37.7832792690603, -122.439769329053) | 15 | 5 | 11 | 29490 | 41 | |||
45559 | 8390 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004488.7034 | 2114010.5767 | 37.7849237683164 | -122.428202546761 | (37.7849237683164, -122.428202546761) | 13 | 9 | 11 | 29490 | 41 | |||
66177 | 109347 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 59x BURNSIDE AVE | 1 | Median : Yard | Tree | DPW 1 | 14 | 6001229.7 | 2095779.3 | 37.7346801948558 | -122.438171157158 | (37.7346801948558, -122.438171157158) | 2 | 7 | 5 | 63 | 7 | ||||
107231 | 8560 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1994 12:00:00 AM | 6 | 3X3 | 6001214.79121 | 2113518.75863 | 37.7833875775095 | -122.439493935571 | (37.7833875775095, -122.439493935571) | 15 | 5 | 11 | 29490 | 13 | ||
129439 | 4367 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 973 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001101.12966 | 2096102.69208 | 37.7355608412513 | -122.438638832041 | (37.7355608412513, -122.438638832041) | 2 | 7 | 5 | 63 | 7 | |||
144700 | 118538 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7900x Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 11 | Width 4ft | 5982472.23583 | 2112389.87128 | 37.7792034803758 | -122.504251064408 | (37.7792034803758, -122.504251064408) | 11 | 6 | 2 | 55 | 26 | |||
145424 | 211006 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 600x Portola Dr | 1 | Median : Cutout | Tree | DPW 1 | 6 | Width 4ft | 5997174.86391 | 2099677.95775 | 37.7451535147355 | -122.452471281937 | (37.7451535147355, -122.452471281937) | 1 | 7 | 4 | 59 | 40 | |||
150152 | 120624 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 41 | |||||
153963 | 24789 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 7700 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 6 | 4X4 | 5983110.07731 | 2112460.67779 | 37.7794353864392 | -122.502049785013 | (37.7794353864392, -122.502049785013) | 11 | 6 | 2 | 55 | 26 | |||
154769 | 255363 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700X Brotherhood Way | 1 | Median : Cutout | Tree | DPW 1 | 6x10 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
162963 | 243101 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 1 | Median : Yard | Tree | DPW 1 | 01/09/2018 12:00:00 AM | 3 | 6001501.83115 | 2098971.73396 | 37.7434613467555 | -122.437458843264 | (37.7434613467555, -122.437458843264) | 2 | 7 | 5 | 63 | 7 | |||
178910 | 61559 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1096 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 08/25/1984 12:00:00 AM | 16 | Permit Number 21519 | 6012461.11053783 | 2102868.78681941 | 37.7547787864142 | -122.399837764002 | (37.7547787864142, -122.399837764002) | 10 | 3 | 8 | 28856 | 29 | ||
183037 | 8530 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2100X Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 06/10/1994 12:00:00 AM | 15 | 6001630.1932 | 2113615.3325 | 37.7836763773468 | -122.438063730933 | (37.7836763773468, -122.438063730933) | 15 | 5 | 11 | 29490 | 41 | |||
21559 | 8344 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1300 Geary Blvd | 10 | Median : Cutout | Tree | DPW 1 | 06/08/1994 12:00:00 AM | 12 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | ||
122378 | 101036 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1010X Portola Dr | 10 | Front Yard : Yard | Tree | DPW 1 | 04/11/2013 12:00:00 AM | 3 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | 1 | 7 | 4 | 59 | 40 | |||
146907 | 243109 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 10 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001750.32805 | 2098751.0187 | 37.7428694390712 | -122.436583810118 | (37.7428694390712, -122.436583810118) | 2 | 7 | 5 | 63 | 7 | |||
69254 | 111516 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 800x BOSWORTH ST | 11 | Front Yard : Yard | Tree | DPW 1 | 14 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
110569 | 8474 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1900 Geary Blvd | 11 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6001879.2717 | 2113651.882 | 37.7837908949329 | -122.437204633286 | (37.7837908949329, -122.437204633286) | 13 | 5 | 11 | 29490 | 41 | |||
54454 | 200536 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 12 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6016175.6148 | 2095666.5235 | 37.7352092330314 | -122.38648971191 | (37.7352092330314, -122.38648971191) | 10 | 3 | 8 | 58 | 1 | |||
127126 | 8475 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1900 Geary Blvd | 12 | Median : Cutout | Tree | DPW 1 | 06/03/1994 12:00:00 AM | 6 | 8 | 6001831.8926 | 2113645.1136 | 37.7837696172579 | -122.437368062109 | (37.7837696172579, -122.437368062109) | 13 | 5 | 11 | 29490 | 41 | ||
164072 | 2266 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700X Brotherhood Way | 12 | Median : Cutout | Tree | DPW 1 | 04/04/2014 12:00:00 AM | 22 | 14M | Permit Number 772491 | 5991180.7931196 | 2088069.9959997 | 37.7129357180907 | -122.472351488932 | (37.7129357180907, -122.472351488932) | 1 | 8 | 4 | 64 | 14 | |
187095 | 21459 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2701X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | 5985119.0068215 | 2096832.7848434 | 37.7366433445438 | -122.493948101207 | (37.7366433445438, -122.493948101207) | 1 | 8 | 3 | 29491 | 35 | |||
115061 | 243111 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 13 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001795.3662 | 2098698.75734 | 37.7427285009166 | -122.436424341429 | (37.7427285009166, -122.436424341429) | 2 | 7 | 5 | 63 | 7 | |||
141624 | 8586 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 13 | Median : Cutout | Tree | DPW 1 | 24 | 6 | 6000400.7068 | 2113377.2527 | 37.7829526738098 | -122.442300177437 | (37.7829526738098, -122.442300177437) | 15 | 5 | 1 | 29490 | 41 | |||
40897 | 21491 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2792X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5985060.3629888 | 2096294.4798015 | 37.7351618711636 | -122.49411119238 | (37.7351618711636, -122.49411119238) | 1 | 8 | 3 | 29491 | 35 | |||
125264 | 8348 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1300 Geary Blvd | 14 | Median : Cutout | Tree | DPW 1 | 06/08/1994 12:00:00 AM | 6 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | ||
165137 | 101040 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1010X Portola Dr | 14 | Front Yard : Yard | Tree | DPW 1 | 04/11/2013 12:00:00 AM | 3 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | 1 | 7 | 4 | 59 | 40 | |||
39949 | 8349 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1300 Geary Blvd | 15 | Median : Cutout | Tree | DPW 1 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | |||
87630 | 243112 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 15 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001806.81928 | 2098684.11193 | 37.7426889388393 | -122.436383692077 | (37.7426889388393, -122.436383692077) | 2 | 7 | 5 | 63 | 7 | |||
135146 | 243113 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 16 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001816.52967 | 2098672.65474 | 37.7426580318326 | -122.436349296602 | (37.7426580318326, -122.436349296602) | 2 | 7 | 5 | 63 | 7 | |||
45135 | 111279 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700X BOSWORTH ST | 17 | Front Yard : Yard | Tree | DPW 1 | 24 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
113834 | 243114 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 17 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001830.21459 | 2098656.61242 | 37.7426147609522 | -122.436300830338 | (37.7426147609522, -122.436300830338) | 2 | 7 | 5 | 63 | 7 | |||
161286 | 8351 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1300 Geary Blvd | 17 | Median : Cutout | Tree | DPW 1 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | |||
54931 | 200542 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 18 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6016191.4179 | 2095647.8311 | 37.7351587822654 | -122.38643377144 | (37.7351587822654, -122.38643377144) | 10 | 3 | 8 | 58 | 1 | |||
68490 | 243115 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 18 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001841.69539 | 2098643.31719 | 37.7425789076843 | -122.436260181872 | (37.7425789076843, -122.436260181872) | 2 | 7 | 5 | 63 | 7 | |||
138421 | 243116 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5300x Diamond Heights Blvd | 19 | Median : Yard | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 3 | 6001856.44522 | 2098624.22352 | 37.7425273189785 | -122.436207815256 | (37.7425273189785, -122.436207815256) | 2 | 7 | 5 | 63 | 7 | |||
6935 | 258120 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Clarendon Ave | 2 | Median : Cutout | Tree | DPW 1 | 05/26/2019 09:06:00 PM | 3 | 5x5 | ||||||||||||
32345 | 211008 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700x Bosworth St | 2 | Median : Yard | Tree | DPW 1 | 33 | Width 10ft | 6002060.33003 | 2095430.49234 | 37.7337696552405 | -122.435274449372 | (37.7337696552405, -122.435274449372) | 9 | 7 | 5 | 63 | 40 | |||
40576 | 120625 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 6004349 | 2113949 | 37.7847467885767 | -122.428681484586 | (37.7847467885767, -122.428681484586) | 13 | 9 | 11 | 29490 | 41 | |||||
41737 | 115997 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 20X Park St | 2 | Median : Yard | Tree | DPW 1 | 08/30/2016 09:25:00 AM | 3 | 6004982.6 | 2096420.1 | 37.7366524147431 | -122.425241679782 | (37.7366524147431, -122.425241679782) | 2 | 7 | 5 | 28859 | 2 | |||
65698 | 8391 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004438.3798 | 2114005.2394 | 37.784906265949 | -122.428376269712 | (37.784906265949, -122.428376269712) | 13 | 9 | 11 | 29490 | 41 | |||
69447 | 111507 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 800x BOSWORTH ST | 2 | Front Yard : Yard | Tree | DPW 1 | 18 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
83122 | 2045 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700X Bosworth St | 2 | Median : Cutout | Tree | DPW 1 | 24 | 10 | 6002154.6210393 | 2095431.8532492 | 37.7337787461998 | -122.434948555048 | (37.7337787461998, -122.434948555048) | 2 | 7 | 5 | 63 | 7 | |||
86234 | 173745 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Grand View Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000114 | 2102099 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | 2 | 4 | 5 | 28862 | 22 | ||||
97385 | 112912 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 480X BEACON ST | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 30 | 6002571 | 2098077 | 37.7410653426557 | -122.433697996676 | (37.7410653426557, -122.433697996676) | 2 | 7 | 5 | 63 | 7 | ||||
103704 | 255364 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700X Brotherhood Way | 2 | Median : Cutout | Tree | DPW 1 | 6x10 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
107565 | 252925 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700 Sanchez St | 2 | Front Yard : Yard | Tree | DPW 1 | 6003672 | 2104202 | 37.757945572264 | -122.430328029181 | (37.757945572264, -122.430328029181) | 2 | 4 | 5 | 28862 | 3 | |||||
113256 | 8561 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1994 12:00:00 AM | 6 | 3X3 | 6001214.79121 | 2113518.75863 | 37.7833875775095 | -122.439493935571 | (37.7833875775095, -122.439493935571) | 15 | 5 | 11 | 29490 | 13 | ||
116060 | 8575 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 48 | 6 | 6001093.7947 | 2113474.2106 | 37.7832583731226 | -122.439909339764 | (37.7832583731226, -122.439909339764) | 15 | 5 | 11 | 29490 | 41 | |||
124888 | 2268 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 750X Brotherhood Way | 2 | Median : Cutout | Tree | DPW 1 | 6 | 14M | 5991074.0426161 | 2088106.2478104 | 37.7130290777882 | -122.47272309172 | (37.7130290777882, -122.47272309172) | 1 | 8 | 4 | 64 | 14 | |||
166211 | 211005 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 800x Portola Dr | 2 | Median : Cutout | Tree | DPW 1 | 7 | Width 4ft | 5996562.64616 | 2099171.26049 | 37.7437271539842 | -122.454551615288 | (37.7437271539842, -122.454551615288) | 1 | 7 | 4 | 59 | 40 | |||
179540 | 200526 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 2 | Median : Cutout | Tree | DPW 1 | 20 | Width 0ft | 6016126.5305 | 2095710.5736 | 37.7353274684402 | -122.386662486514 | (37.7353274684402, -122.386662486514) | 10 | 3 | 8 | 58 | 1 | |||
194284 | 4966 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5200X Diamond Heights Blvd | 2 | Median : Cutout | Tree | DPW 1 | 12/03/2018 12:00:00 AM | 3 | 12 | 6000791.48606 | 2099581.9209 | 37.7450963646197 | -122.439958774198 | (37.7450963646197, -122.439958774198) | 2 | 7 | 5 | 63 | 7 | ||
22825 | 200547 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 23 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6016201.7309 | 2095635.0286 | 37.7351242000527 | -122.386397222999 | (37.7351242000527, -122.386397222999) | 10 | 3 | 8 | 58 | 1 | |||
168039 | 21429 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2692X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | |||
49351 | 21431 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2692X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | |||
1049 | 120626 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 41 | |||||
5625 | 19976 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 100 STAIRWAY45 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30ST | |||||||||||||
13843 | 20301 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 50X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
14131 | 258121 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Clarendon Ave | 3 | Median : Cutout | Tree | DPW 1 | 05/26/2019 09:09:00 PM | 3 | 5x5 | ||||||||||||
23996 | 8576 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 48 | 6 | 6001010.5429 | 2113459.32 | 37.7832127479531 | -122.440196288881 | (37.7832127479531, -122.440196288881) | 15 | 5 | 11 | 29490 | 41 | |||
71060 | 200527 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 3 | Median : Cutout | Tree | DPW 1 | 15 | Width 0ft | 6016132.8234 | 2095707.6369 | 37.7353197532414 | -122.386640524716 | (37.7353197532414, -122.386640524716) | 10 | 3 | 8 | 58 | 1 | |||
71757 | 8562 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 3X3 | 6001214.79121 | 2113518.75863 | 37.7833875775095 | -122.439493935571 | (37.7833875775095, -122.439493935571) | 15 | 5 | 11 | 29490 | 13 | |||
74880 | 8392 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004378.144 | 2113996.8521 | 37.7848798278423 | -122.428584068109 | (37.7848798278423, -122.428584068109) | 13 | 9 | 11 | 29490 | 41 | |||
113773 | 111508 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 800x BOSWORTH ST | 3 | Front Yard : Yard | Tree | DPW 1 | 18 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
126371 | 8532 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2100 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 06/10/1994 12:00:00 AM | 6 | 6 | 6001535.4351 | 2113580.6442 | 37.7835757427727 | -122.438389071264 | (37.7835757427727, -122.438389071264) | 15 | 5 | 11 | 29490 | 41 | ||
175848 | 111265 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 700X BOSWORTH ST | 3 | Front Yard : Yard | Tree | DPW 1 | 20 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
177341 | 139329 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1350x GEARY BLVD | 3 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6005196.3246 | 2114113.3931 | 37.7852460889347 | -122.425761723999 | (37.7852460889347, -122.425761723999) | 13 | 9 | 11 | 28858 | 41 | |||
193081 | 173746 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Grand View Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000114 | 2102099 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | 2 | 4 | 5 | 28862 | 22 | ||||
37212 | 111553 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 900x BOSWORTH ST | 31 | Front Yard : Yard | Tree | DPW 1 | 12 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
171251 | 111554 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 900x BOSWORTH ST | 32 | Front Yard : Yard | Tree | DPW 1 | 26 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
150320 | 111555 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 900x BOSWORTH ST | 33 | Front Yard : Yard | Tree | DPW 1 | 24 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
178827 | 200557 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 33 | Median : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6016298.6383 | 2095516.7839 | 37.7348048876468 | -122.386053935891 | (37.7348048876468, -122.386053935891) | 10 | 3 | 8 | 58 | 1 | |||
136381 | 200558 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 34 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6016305.3951 | 2095506.8264 | 37.7347779203 | -122.386029881179 | (37.7347779203, -122.386029881179) | 10 | 3 | 8 | 58 | 1 | |||
86690 | 200559 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 35 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6016309.6626 | 2095501.1365 | 37.7347625331555 | -122.38601473032 | (37.7347625331555, -122.38601473032) | 10 | 3 | 8 | 58 | 1 | |||
147440 | 111557 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 900x BOSWORTH ST | 35 | Front Yard : Yard | Tree | DPW 1 | 12 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
101189 | 111558 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 900x BOSWORTH ST | 36 | Front Yard : Yard | Tree | DPW 1 | 15 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
158562 | 200567 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 39 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6016322.0539 | 2095480.6054 | 37.7347068446432 | -122.385970458247 | (37.7347068446432, -122.385970458247) | 10 | 3 | 8 | 58 | 1 | |||
6586 | 258122 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 500X Clarendon Ave | 4 | Median : Cutout | Tree | DPW 1 | 05/26/2019 09:11:00 PM | 3 | 5x5 | ||||||||||||
54682 | 8393 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004320.9581 | 2113985.4149 | 37.7848451877241 | -122.428781097193 | (37.7848451877241, -122.428781097193) | 13 | 9 | 11 | 29490 | 41 | |||
65234 | 8577 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 36 | 6 | 6000958.4259 | 2113453.9053 | 37.7831949132778 | -122.440376203878 | (37.7831949132778, -122.440376203878) | 15 | 5 | 11 | 29490 | 41 | |||
65641 | 139330 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1350x GEARY BLVD | 4 | Median : Cutout | Tree | DPW 1 | 31 | Width 0ft | 6005126.2471 | 2114101.4827 | 37.7852094256692 | -122.426003322666 | (37.7852094256692, -122.426003322666) | 13 | 9 | 11 | 28858 | 41 | |||
66433 | 8563 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6001214.79121 | 2113518.75863 | 37.7833875775095 | -122.439493935571 | (37.7833875775095, -122.439493935571) | 15 | 5 | 11 | 29490 | 13 | |||
71238 | 200528 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 4 | Median : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6016143.3115 | 2095696.7293 | 37.7352903838014 | -122.386603502798 | (37.7352903838014, -122.386603502798) | 10 | 3 | 8 | 58 | 1 | |||
156411 | 120627 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 41 | |||||
194257 | 4968 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 5200X Diamond Heights Blvd | 4 | Median : Cutout | Tree | DPW 1 | 12/03/2018 12:00:00 AM | 3 | 12 | 6000815.91312 | 2099549.13893 | 37.7450077436274 | -122.439871959934 | (37.7450077436274, -122.439871959934) | 2 | 7 | 5 | 63 | 7 | ||
131403 | 200571 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 41 | Median : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6016326.461 | 2095462.4873 | 37.7346573398722 | -122.385953958726 | (37.7346573398722, -122.385953958726) | 10 | 3 | 8 | 58 | 1 | |||
122774 | 200572 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 42 | Median : Cutout | Tree | DPW 1 | 18 | Width 0ft | 6016330.8681 | 2095450.735 | 37.7346253143087 | -122.385937902813 | (37.7346253143087, -122.385937902813) | 10 | 3 | 8 | 58 | 1 | |||
169125 | 200573 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 43 | Median : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6016335.7649 | 2095440.4518 | 37.7345973496971 | -122.385920256211 | (37.7345973496971, -122.385920256211) | 10 | 3 | 8 | 58 | 1 | |||
436 | 120628 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 41 | |||||
43907 | 8339 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1300 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 06/08/1994 12:00:00 AM | 18 | 6 | 6005496.3592183 | 2114176.6024527 | 37.7854365962768 | -122.424728193484 | (37.7854365962768, -122.424728193484) | 13 | 9 | 11 | 28858 | 13 | ||
83492 | 116067 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 4150X CLEMENT ST | 5 | Front Yard : Yard | Tree | DPW 1 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777818 | 5983115 | 2113126 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) | 11 | 6 | 2 | 55 | 15 | |
97674 | 8394 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004234.0356 | 2113977.7901 | 37.784819331933 | -122.429081276927 | (37.784819331933, -122.429081276927) | 13 | 9 | 11 | 29490 | 41 | |||
110654 | 139356 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1350x GEARY BLVD | 5 | Median : Cutout | Tree | DPW 1 | 24 | Width 0ft | 6005063.0942 | 2114090.4032 | 37.7851754347521 | -122.426221023287 | (37.7851754347521, -122.426221023287) | 13 | 9 | 11 | 28858 | 41 | |||
160462 | 2028 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 600X Bosworth St | 5 | Median : Cutout | Tree | DPW 1 | 12 | 10 | 6002398.10054 | 2095366.8333155 | 37.7336140379052 | -122.434102128474 | (37.7336140379052, -122.434102128474) | 2 | 7 | 5 | 63 | 7 | |||
170733 | 8578 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6000905.6321 | 2113444.4294 | 37.7831658887746 | -122.440558168856 | (37.7831658887746, -122.440558168856) | 15 | 5 | 11 | 29490 | 41 | |||
174672 | 200529 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1400x La Salle Ave | 5 | Median : Cutout | Tree | DPW 1 | 16 | Width 0ft | 6016150.0239 | 2095691.2754 | 37.7352757800904 | -122.386579915171 | (37.7352757800904, -122.386579915171) | 10 | 3 | 8 | 58 | 1 |
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) );