trees
603 rows where qSpecies_id = 172 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194172 | 240286 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 5200x Diamond Heights Blvd | 42 | Median : Yard | Tree | DPW 1 | 2 | 6001709.51148 | 2098788.78469 | 37.7429708160432 | -122.436727644972 | (37.7429708160432, -122.436727644972) | 2 | 7 | 5 | 63 | 7 | ||||
193948 | 240256 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005797.86242 | 2097005.69639 | 37.7383063554532 | -122.422464559209 | (37.7383063554532, -122.422464559209) | 2 | 7 | 7 | 28859 | 2 | |||
193488 | 240320 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 355 Masonic Ave | 6 | Front Yard : Yard | Tree | Private 2 | 12 | Width 3ft | 6000338.40748 | 2106908.57124 | 37.7651877596278 | -122.442051239382 | (37.7651877596278, -122.442051239382) | 15 | 5 | 5 | 28862 | 3 | |||
193001 | 117207 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300x De Haro St | 1 | Median : Cutout | Tree | Private 2 | 13 | 6012255.77341 | 2102253.00873 | 37.753076544652 | -122.40050462841 | (37.753076544652, -122.40050462841) | 10 | 3 | 8 | 28856 | 29 | ||||
192676 | 240315 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 310 Liberty St | 47 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003842.50759 | 2103921.28681 | 37.7571844571259 | -122.429718320863 | (37.7571844571259, -122.429718320863) | 2 | 4 | 5 | 28862 | 3 | |||
192154 | 240242 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 351 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006956.98547 | 2096047.94353 | 37.7357418990697 | -122.418388981867 | (37.7357418990697, -122.418388981867) | 2 | 7 | 7 | 28859 | 2 | |||
191864 | 240222 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 10ft | 6006171.40758 | 2095805.43718 | 37.7350317763766 | -122.421087821261 | (37.7350317763766, -122.421087821261) | 2 | 7 | 7 | 28859 | 2 | |||
191810 | 240279 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1369 Valencia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006475.19087 | 2101646.9491 | 37.7510883747358 | -122.420452035657 | (37.7510883747358, -122.420452035657) | 2 | 4 | 7 | 28859 | 19 | |||
191441 | 197200 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2001 Revere Ave | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6012333.19446 | 2096408.64833 | 37.7370334972934 | -122.39982653777 | (37.7370334972934, -122.39982653777) | 10 | 3 | 8 | 58 | 1 | ||||
190127 | 122355 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
190068 | 122360 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
188325 | 83005 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1601 Lane St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52363 | 6015179.2236 | 2094481.4485 | 37.7319000489922 | -122.389851877282 | (37.7319000489922, -122.389851877282) | 10 | 3 | 8 | 58 | 1 | |
188279 | 247115 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2301 Castro St | 33 | Front Yard : Yard | Tree | Private 2 | 2 | 6002710.00454 | 2098655.04681 | 37.7426604114562 | -122.433258663951 | (37.7426604114562, -122.433258663951) | 2 | 7 | 5 | 63 | 22 | ||||
188140 | 240220 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 10ft | 6006143.46511 | 2095809.04412 | 37.735040105008 | -122.421184684532 | (37.735040105008, -122.421184684532) | 2 | 7 | 7 | 28859 | 2 | |||
187620 | 186201 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1701 Sunset Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984749.405 | 2103445.7422 | 37.7547790924201 | -122.495713595878 | (37.7547790924201, -122.495713595878) | 1 | 8 | 3 | 56 | 35 | |||
187334 | 83256 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 606 40th Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/22/2009 12:00:00 AM | 3x3 | Permit Number 52675 | 5983524.4637113 | 2111665.45809924 | 37.7772762800291 | -122.500557454432 | (37.7772762800291, -122.500557454432) | 11 | 6 | 2 | 55 | 26 | ||
187040 | 68765 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 138 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50779 | 6003386.47101078 | 2105092.952527 | 37.7603757374175 | -122.431379108138 | (37.7603757374175, -122.431379108138) | 2 | 4 | 5 | 28862 | 3 | ||
186898 | 43440 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 2 | Permit Number 43162 | 5999628.40371 | 2091200.8294 | 37.7220175764452 | -122.443378608135 | (37.7220175764452, -122.443378608135) | 9 | 7 | 6 | 28861 | 25 | |
186491 | 240299 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 300 Clipper St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002905.19719 | 2100966.1852 | 37.7490173286825 | -122.432748805907 | (37.7490173286825, -122.432748805907) | 2 | 4 | 5 | 28862 | 22 | |||
186064 | 44136 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | 9 | 8 | 6 | 64 | 24 | |||
185856 | 27293 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1628 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x4 | 5990401.75859 | 2114777.42415 | 37.7862221958377 | -122.476994379351 | (37.7862221958377, -122.476994379351) | 11 | 6 | 1 | 55 | 33 | |||
185512 | 44150 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | 9 | 8 | 6 | 64 | 24 | |||
185319 | 240294 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 415 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6001830.81477 | 2103405.33682 | 37.7556536644037 | -122.436638590514 | (37.7556536644037, -122.436638590514) | 2 | 4 | 5 | 28862 | 22 | |||
185182 | 29652 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1500X La Salle Ave | 11 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015669.3226 | 2096063.213 | 37.7362704220955 | -122.388267840771 | (37.7362704220955, -122.388267840771) | 10 | 3 | 8 | 58 | 1 | ||
184999 | 43452 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 10 | Permit Number 43162 | 5999577.25447 | 2091228.40825 | 37.7220903846374 | -122.443557397876 | (37.7220903846374, -122.443557397876) | 9 | 7 | 6 | 28861 | 25 | |
184272 | 44159 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | 9 | 8 | 6 | 64 | 24 | |||
183826 | 90272 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4122 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982765.5809 | 2111043.53002 | 37.7755240685037 | -122.503136574036 | (37.7755240685037, -122.503136574036) | 11 | 6 | 2 | 55 | 26 | ||
183741 | 255653 | Planning Code 138.1 required 2 | Quercus agrifolia :: Coast Live Oak 172 | 298X Coso Ave | 1 | Side Yard : Yard | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 10x10 | Permit Number 776462 | 6007785 | 2099424 | 37.7450583812321 | -122.415765181935 | (37.7450583812321, -122.415765181935) | 2 | 7 | 7 | 28859 | 2 | |
183613 | 57335 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 425 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50433 | 6001836.44387849 | 2103368.43988301 | 37.7555526741853 | -122.436616482406 | (37.7555526741853, -122.436616482406) | 2 | 4 | 5 | 28862 | 22 | ||
182740 | 184050 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1600 Sunset Blvd | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984953.7413 | 2103846.6967 | 37.7558919667936 | -122.495036518918 | (37.7558919667936, -122.495036518918) | 1 | 8 | 3 | 56 | 35 | |||
182101 | 247103 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2301 Castro St | 21 | Front Yard : Yard | Tree | Private 2 | 3 | 6002737.73752 | 2098774.19927 | 37.7429891496381 | -122.433171283123 | (37.7429891496381, -122.433171283123) | 2 | 7 | 5 | 63 | 22 | ||||
182050 | 18938 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2730 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/21/2001 12:00:00 AM | 6 | 4X4 | 6001751.73398 | 2115704.11419 | 37.7894185478752 | -122.437792899137 | (37.7894185478752, -122.437792899137) | 13 | 6 | 1 | 29490 | 27 | ||
181117 | 113496 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 200x Mansell St | 2 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | 6011235.51183 | 2090583.52363 | 37.7209776633755 | -122.403212099473 | (37.7209776633755, -122.403212099473) | 10 | 3 | 7 | 309 | 28 | |||
181079 | 202105 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1828 Egbert Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6012005.05891 | 2092897.14051 | 37.727373329703 | -122.40071444024 | (37.727373329703, -122.40071444024) | 10 | 3 | 8 | 58 | 1 | |||
180372 | 185715 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2101 Sunset Blvd | 47 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | Width 0ft | 5984885.2791 | 2100401.0884 | 37.7464272644724 | -122.495019222701 | (37.7464272644724, -122.495019222701) | 1 | 8 | 3 | 29491 | 35 | |||
179875 | 200029 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1575 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015274.8561 | 2094571.5849 | 37.7321528483199 | -122.38952754545 | (37.7321528483199, -122.38952754545) | 10 | 3 | 8 | 58 | 1 | |||
179844 | 240302 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4185 25th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002703.68408 | 2101206.46382 | 37.7496656463533 | -122.433462807366 | (37.7496656463533, -122.433462807366) | 2 | 4 | 5 | 28862 | 22 | |||
179483 | 214001 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 10 Caine Ave | 14 | : | Tree | Private 2 | 5 | Width 0ft | 5997555.12173 | 2089578.95708 | 37.7174458422426 | -122.450428532174 | (37.7174458422426, -122.450428532174) | 9 | 8 | 6 | 28861 | 24 | |||
179082 | 46625 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1601 Lane St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52363 | 6015155.0407 | 2094448.4718 | 37.7318081605067 | -122.389933180674 | (37.7318081605067, -122.389933180674) | 10 | 3 | 8 | 58 | 1 | |
178842 | 247918 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1098 Esmeralda Ave | 3 | Side Yard : Yard | Tree | Private 2 | 4 | 6010239.20977 | 2098728.38698 | 37.7432860401182 | -122.407229893555 | (37.7432860401182, -122.407229893555) | 10 | 7 | 7 | 28859 | 2 | ||||
178628 | 247898 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 351 Mayflower St | 3 | Side Yard : Yard | Tree | Private 2 | 13 | 6010067.01761 | 2098387.06443 | 37.7423392041886 | -122.407801229241 | (37.7423392041886, -122.407801229241) | 10 | 7 | 7 | 28859 | 2 | ||||
178335 | 184054 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1600 Sunset Blvd | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984938.5987 | 2103876.5136 | 37.7559729492589 | -122.495091084788 | (37.7559729492589, -122.495091084788) | 1 | 8 | 3 | 56 | 35 | |||
177390 | 247612 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 300 Bradford St | 3 | Front Yard : Yard | Tree | Private 2 | 2 | 6009485.09614 | 2096718.12659 | 37.7377240687023 | -122.409695572001 | (37.7377240687023, -122.409695572001) | 10 | 7 | 7 | 28859 | 2 | ||||
177369 | 122366 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
177162 | 90271 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4100X Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982889.660166 | 2111040.818849 | 37.7755239169344 | -122.502707160377 | (37.7755239169344, -122.502707160377) | 11 | 6 | 2 | 55 | 26 | |
177133 | 197208 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 91 Kiska Rd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6019334.40687 | 2093641.64666 | 37.7298236693276 | -122.375428176194 | (37.7298236693276, -122.375428176194) | 10 | 3 | 8 | 58 | 1 | ||||
176496 | 240218 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 10ft | 6006103.73166 | 2095810.88544 | 37.7350429207983 | -122.421322188175 | (37.7350429207983, -122.421322188175) | 2 | 7 | 7 | 28859 | 2 | |||
176251 | 247620 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 300 Bradford St | 11 | Front Yard : Yard | Tree | Private 2 | 3 | 6009499.0149 | 2096845.57138 | 37.7380747845204 | -122.409656440699 | (37.7380747845204, -122.409656440699) | 10 | 7 | 7 | 28859 | 2 | ||||
176100 | 90288 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4790X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980763.025413 | 2110963.934321 | 37.7751876098256 | -122.51005785431 | (37.7751876098256, -122.51005785431) | 11 | 6 | 2 | 55 | 26 | |
175178 | 247912 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 399 Franconia St | 3 | Side Yard : Yard | Tree | Private 2 | 13 | 6009971.11183 | 2098794.45901 | 37.7434524515605 | -122.408161569622 | (37.7434524515605, -122.408161569622) | 2 | 7 | 7 | 28859 | 2 | ||||
174995 | 240252 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6005881.16344 | 2096962.50906 | 37.738192471607 | -122.422173477431 | (37.738192471607, -122.422173477431) | 2 | 7 | 7 | 28859 | 2 | |||
174772 | 42688 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 2500 Larkin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42711 | 6006694.5506046 | 2119774.0082852 | 37.8008732765742 | -122.420980361587 | (37.8008732765742, -122.420980361587) | 5 | 9 | 1 | 28858 | 32 | |||
172657 | 240236 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 20 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 6006373.31907 | 2095788.53598 | 37.7349967496044 | -122.420388540807 | (37.7349967496044, -122.420388540807) | 2 | 7 | 7 | 28859 | 2 | |||
172315 | 95546 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 665 29th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767345 | 6002290 | 2098847 | 37.7431636344912 | -122.434724639657 | (37.7431636344912, -122.434724639657) | 2 | 7 | 5 | 63 | 7 | |
172013 | 43433 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 16 | Permit Number 43162 | 5999846.51913 | 2091089.02473 | 37.7217230223792 | -122.442616616172 | (37.7217230223792, -122.442616616172) | 9 | 7 | 6 | 28861 | 25 | |
171828 | 90244 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2900X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986220.07913 | 2111172.67589 | 37.7760811139804 | -122.491196306516 | (37.7760811139804, -122.491196306516) | 11 | 6 | 2 | 55 | 26 | ||
170903 | 179346 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 111 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6004743.0308 | 2092717.80551 | 37.7264732027495 | -122.425806528059 | (37.7264732027495, -122.425806528059) | 9 | 7 | 6 | 28861 | 5 | ||||
170562 | 240311 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 310 Liberty St | 39 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 6003913.51755 | 2103937.88547 | 37.757234053829 | -122.42947392468 | (37.757234053829, -122.42947392468) | 2 | 4 | 5 | 28862 | 3 | |||
170374 | 240292 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2858 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009059.85584 | 2103354.08041 | 37.7559210904145 | -122.411634568798 | (37.7559210904145, -122.411634568798) | 2 | 4 | 7 | 28859 | 19 | |||
170203 | 186826 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1200 Sunset Blvd | 99 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984816.4913 | 2106624.0982 | 37.7635099007919 | -122.495716026683 | (37.7635099007919, -122.495716026683) | 1 | 8 | 3 | 56 | 35 | |||
170072 | 247907 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 582 Esmeralda Ave | 5 | Side Yard : Yard | Tree | Private 2 | 7 | 6009851.66024 | 2098739.23116 | 37.7432941187313 | -122.408570709864 | (37.7432941187313, -122.408570709864) | 2 | 7 | 7 | 28859 | 2 | ||||
170068 | 185913 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2000 Sunset Blvd | 56 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985043.1337 | 2101408.2259 | 37.7492018292208 | -122.494547620425 | (37.7492018292208, -122.494547620425) | 1 | 8 | 3 | 29491 | 35 | |||
169840 | 34698 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 715 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/2002 12:00:00 AM | 2 | Permit Number 45251 | 5981951.23217 | 2110867.89053 | 37.7749939133636 | -122.505940528656 | (37.7749939133636, -122.505940528656) | 11 | 6 | 2 | 55 | 26 | |
169716 | 197173 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1900 23rd St | 1 | Front Yard : Yard | Tree | Private 2 | 7 | 6012739.26156 | 2102864.49072 | 37.7547824929244 | -122.398875533502 | (37.7547824929244, -122.398875533502) | 10 | 3 | 8 | 28856 | 29 | ||||
168957 | 240280 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 691 29th St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6002099.07466 | 2098828.06304 | 37.7431007968732 | -122.435383453493 | (37.7431007968732, -122.435383453493) | 2 | 7 | 5 | 63 | 7 | ||||
168947 | 240308 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6002991.75361 | 2104713.00594 | 37.7593101171863 | -122.432717109334 | (37.7593101171863, -122.432717109334) | 2 | 4 | 5 | 28862 | 3 | |||
168943 | 247632 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1021 Jarboe Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6009462.56888 | 2096880.39519 | 37.7381683607742 | -122.409784910667 | (37.7381683607742, -122.409784910667) | 10 | 7 | 7 | 28859 | 2 | ||||
168158 | 90298 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4527 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5981574.06475 | 2110953.226782 | 37.7752060137503 | -122.507251541607 | (37.7752060137503, -122.507251541607) | 11 | 6 | 2 | 55 | 26 | |
167198 | 44143 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 27 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | 9 | 8 | 6 | 64 | 24 | |||
167175 | 187180 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2301 Sunset Blvd | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984952.2414 | 2099225.3952 | 37.7432030498921 | -122.494701014784 | (37.7432030498921, -122.494701014784) | 1 | 8 | 3 | 29491 | 35 | |||
167080 | 247828 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 97 Banks St | 2 | Front Yard : Yard | Tree | Private 2 | 5 | 6008690.7766 | 2098166.57943 | 37.7416566592328 | -122.412544286997 | (37.7416566592328, -122.412544286997) | 10 | 7 | 7 | 28859 | 2 | ||||
165933 | 52422 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 300 Seneca Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2005 12:00:00 AM | Permit Number 48542 | 5999289.94205438 | 2090904.87008142 | 37.7211856330713 | -122.444527321415 | (37.7211856330713, -122.444527321415) | 9 | 7 | 6 | 28861 | 25 | |||
163826 | 240278 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1369 Valencia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006475.64332 | 2101625.709 | 37.7510300797762 | -122.420448963552 | (37.7510300797762, -122.420448963552) | 2 | 4 | 7 | 28859 | 19 | |||
163218 | 240283 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 689 29th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6002132.41034 | 2098830.92399 | 37.7431105455104 | -122.435268392422 | (37.7431105455104, -122.435268392422) | 2 | 7 | 5 | 63 | 7 | ||||
162688 | 43374 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 415 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43123 | 6001833.61881402 | 2103424.63951289 | 37.7557068243023 | -122.436630274867 | (37.7557068243023, -122.436630274867) | 2 | 4 | 5 | 28862 | 22 | ||
162499 | 240304 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4185 25th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002908.08128 | 2101214.22256 | 37.7496985444673 | -122.432756549089 | (37.7496985444673, -122.432756549089) | 2 | 4 | 5 | 28862 | 22 | |||
161527 | 29651 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1500X La Salle Ave | 10 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015684.3928 | 2096048.7707 | 37.7362316014874 | -122.388214728777 | (37.7362316014874, -122.388214728777) | 10 | 3 | 8 | 58 | 1 | ||
161427 | 92055 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1001 Potrero Ave | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | |||||
161288 | 136277 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2745 Larkin St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6006529.34062 | 2120636.08267 | 37.8032309995586 | -122.421613321221 | (37.8032309995586, -122.421613321221) | 5 | 9 | 1 | 28858 | 32 | ||||
160990 | 197198 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2001 Revere Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6012265.63539 | 2096460.02897 | 37.7371708111791 | -122.400063728568 | (37.7371708111791, -122.400063728568) | 10 | 3 | 8 | 58 | 1 | ||||
160964 | 122363 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
160862 | 90295 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4899X Balboa St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980415.19176 | 2110911.332666 | 37.7750226590497 | -122.511257155794 | (37.7750226590497, -122.511257155794) | 11 | 6 | 2 | 55 | 26 | |
160547 | 184053 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1600 Sunset Blvd | 54 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984911.7478 | 2103852.1605 | 37.7559045104069 | -122.495182146902 | (37.7559045104069, -122.495182146902) | 1 | 8 | 3 | 56 | 35 | |||
160539 | 186816 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1200 Sunset Blvd | 111 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984817.9648 | 2106815.6539 | 37.7640359452212 | -122.495725060944 | (37.7640359452212, -122.495725060944) | 1 | 8 | 3 | 56 | 35 | |||
160401 | 186020 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1900 Sunset Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984992.5321 | 2101870.4232 | 37.7504679347635 | -122.494756670905 | (37.7504679347635, -122.494756670905) | 1 | 8 | 3 | 29491 | 35 | |||
159166 | 184356 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1251 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984656.2754 | 2106611.6026 | 37.7634662075597 | -122.496269232033 | (37.7634662075597, -122.496269232033) | 1 | 8 | 3 | 56 | 35 | |||
158855 | 185682 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2101 Sunset Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984846.7043 | 2100650.5167 | 37.7471098682936 | -122.495170998311 | (37.7471098682936, -122.495170998311) | 1 | 8 | 3 | 29491 | 35 | |||
158798 | 122362 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
158309 | 247107 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2301 Castro St | 25 | Front Yard : Yard | Tree | Private 2 | 4 | 6002697.86088 | 2098808.57666 | 37.7430812797894 | -122.433311621447 | (37.7430812797894, -122.433311621447) | 2 | 7 | 5 | 63 | 22 | ||||
158141 | 247970 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 159 Faith St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 8ft | 6010298.66575 | 2099104.32096 | 37.7443216004603 | -122.407050801679 | (37.7443216004603, -122.407050801679) | 2 | 7 | 7 | 28859 | 2 | |||
158058 | 240312 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 310 Liberty St | 40 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 6003905.57724 | 2103937.67287 | 37.7572330205097 | -122.429501370197 | (37.7572330205097, -122.429501370197) | 2 | 4 | 5 | 28862 | 3 | |||
157676 | 246710 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1 Bonview St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6007732.83024 | 2099171.31283 | 37.7443616257 | -122.415927685808 | (37.7443616257, -122.415927685808) | 2 | 7 | 7 | 28859 | 2 | ||||
157597 | 200033 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1575 Quesada Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015359.4964 | 2094508.3795 | 37.7319839916649 | -122.389230510733 | (37.7319839916649, -122.389230510733) | 10 | 3 | 8 | 58 | 1 | |||
157423 | 186273 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1800 Sunset Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984998.9886 | 2102484.3595 | 37.7521540132755 | -122.494779603218 | (37.7521540132755, -122.494779603218) | 1 | 8 | 3 | 56 | 35 | |||
157388 | 247095 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2301 Castro St | 13 | Front Yard : Yard | Tree | Private 2 | 9 | 6002730.40723 | 2098617.72179 | 37.7425590830422 | -122.433185451064 | (37.7425590830422, -122.433185451064) | 2 | 7 | 5 | 63 | 22 | ||||
157288 | 90245 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2900X Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986200.19499 | 2111171.72975 | 37.7760773543178 | -122.491265020448 | (37.7760773543178, -122.491265020448) | 11 | 6 | 2 | 55 | 26 | ||
156991 | 179339 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 340 Tocoloma Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6012524.83653 | 2086861.12373 | 37.7108286189149 | -122.398494192156 | (37.7108286189149, -122.398494192156) | 10 | 3 | 8 | 309 | 1 | |||
156811 | 240255 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6005819.32929 | 2096993.78331 | 37.7382748557875 | -122.422389490999 | (37.7382748557875, -122.422389490999) | 2 | 7 | 7 | 28859 | 2 | |||
156431 | 247194 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 900 Waller St | 8 | Front Yard : Yard | Tree | Private 2 | 14 | 6001245.27883 | 2108670.04776 | 37.7700759760472 | -122.439040848753 | (37.7700759760472, -122.439040848753) | 15 | 5 | 11 | 29492 | 9 | ||||
156274 | 197171 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 670 Illinois St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6015971.35988 | 2105878.87725 | 37.7632389206717 | -122.387908275953 | (37.7632389206717, -122.387908275953) | 14 | 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) );