trees

1,732 rows where qLegalStatus_id = 6 sorted by TreeID

✎ View and edit SQL

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)
125330 104932 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 717 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990427 2090598 37.7198333383806 -122.475141254145 (37.7198333383806, -122.475141254145) 1 8 4 64 40
181383 104933 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 755 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990427 2090598 37.7198333383806 -122.475141254145 (37.7198333383806, -122.475141254145) 1 8 4 64 40
138477 104934 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 805 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990419 2090610 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631) 1 8 4 64 40
9997 104935 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 835 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990419 2090610 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631) 1 8 4 64 40
113390 104936 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 837 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990419 2090610 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631) 1 8 4 64 40
126137 104937 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 839 Gonzalez Dr 2 Front Yard : Yard Tree Private 2           5990419 2090610 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631) 1 8 4 64 40
119882 105045 Significant Tree 6 Tree(s) :: 17 1899X Eddy St 3 Front Yard : Yard Tree Private 2   02/21/2014 12:00:00 AM     Permit Number 772599 6001374.8 2112478.6 37.7805406719806 -122.438865805362 (37.7805406719806, -122.438865805362) 15 5 11 29490 41
83971 105071 Significant Tree 6 Acacia stenophylla :: Shoestring Acacia 30 1808 Vallejo St 1 Front Yard : Yard Tree Private 2     3   Permit Number 771033 6004794.05676 2118138.55822 37.7962754378239 -122.427440299436 (37.7962754378239, -122.427440299436) 13 9 1 57 17
154007 105073 Significant Tree 6 Myoporum laetum :: Myoporum 62 101 LUNDYS LN 1 Front Yard : Cutout Tree Private 2     18     6006875 2098969 37.7437578546964 -122.418879543436 (37.7437578546964, -122.418879543436) 2 7 7 28859 2
15911 105081 Significant Tree 6 :: 45 344 Fulton St 1 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
126537 105082 Significant Tree 6 :: 45 344 Fulton St 2 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
167444 105083 Significant Tree 6 :: 45 344 Fulton St 3 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
75459 105084 Significant Tree 6 :: 45 344 Fulton St 4 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
145102 105085 Significant Tree 6 :: 45 344 Fulton St 5 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
17108 105086 Significant Tree 6 :: 45 344 Fulton St 6 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
154153 105087 Significant Tree 6 :: 45 344 Fulton St 7 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
186789 105088 Significant Tree 6 :: 45 344 Fulton St 8 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
803 105089 Significant Tree 6 :: 45 344 Fulton St 9 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
161677 105090 Significant Tree 6 :: 45 344 Fulton St 10 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
91093 105091 Significant Tree 6 :: 45 344 Fulton St 11 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
7291 105130 Significant Tree 6 Tree(s) :: 17 4045 MORAGA ST   Sidewalk: Property side : Yard Tree Private 2           5981665.2 2103465.9 37.7546533409301 -122.506380933635 (37.7546533409301, -122.506380933635) 1 8 3 56 35
179978 105160 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1600X OAKDALE AVE 1 Front Yard : Yard Tree Arts Commission 19     13   Permit Number 770204 6015006 2095503 37.7346954145828 -122.390522107646 (37.7346954145828, -122.390522107646) 10 3 8 58 1
29803 105161 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1600X Oakdale Ave 2 Front Yard : Cutout Tree Arts Commission 19     13 3x3   6014869.34112 2095641.83637 37.735069048787 -122.391004288315 (37.735069048787, -122.391004288315) 10 3 8 58 1
15723 105168 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 4755X 03RD ST 2 Front Yard : Cutout Tree Arts Commission 19     23 3x3 Permit Number 770204 6015032 2095658 37.7351224553975 -122.390443042679 (37.7351224553975, -122.390443042679) 10 3 8 58 1
44150 105208 Significant Tree 6 Myoporum laetum :: Myoporum 62 2694 47TH AVE   Front Yard : Yard Tree Private 2           5981878.3 2096771.8 37.7362857499502 -122.505147911282 (37.7362857499502, -122.505147911282) 1 8 3 29491 35
25451 105226 Significant Tree 6 Tree(s) :: 17 1150X Golden Gate Ave 1 Front Yard : Yard Tree Private 2   01/02/2014 12:00:00 AM     Permit Number 771276 6004329.61165 2112216.22051 37.7799879097685 -122.428625001082 (37.7799879097685, -122.428625001082) 7 9 11 29490 41
165618 105227 Significant Tree 6 Tree(s) :: 17 1150X Golden Gate Ave 2 Front Yard : Yard Tree Private 2   01/02/2014 12:00:00 AM     Permit Number 771276 6004329.61165 2112216.22051 37.7799879097685 -122.428625001082 (37.7799879097685, -122.428625001082) 7 9 11 29490 41
149146 105234 Significant Tree 6 Olea europaea :: Olive Tree 9 250 STATES ST 5 Front Yard : Yard Tree Private 2     12     6000595.6 2106681.2 37.7645781078798 -122.441145360444 (37.7645781078798, -122.441145360444) 15 5 5 28862 3
20207 105239 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 6 Front Yard : Yard Tree Private 2   01/06/2014 12:00:00 AM     Permit Number 770859 6005004.4 2113886.9 37.7846133478309 -122.426409592351 (37.7846133478309, -122.426409592351) 13 9 11 28858 41
27763 105240 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 10 Front Yard : Yard Tree Private 2   01/06/2014 12:00:00 AM     Permit Number 770859 6005004.4 2113886.9 37.7846133478309 -122.426409592351 (37.7846133478309, -122.426409592351) 13 9 11 28858 41
117572 105241 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 11 Front Yard : Yard Tree Private 2   01/06/2014 12:00:00 AM     Permit Number 770859 6005004.4 2113886.9 37.7846133478309 -122.426409592351 (37.7846133478309, -122.426409592351) 13 9 11 28858 41
117668 105242 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 14 Front Yard : Yard Tree Private 2   01/06/2014 12:00:00 AM     Permit Number 770859 6005004.4 2113886.9 37.7846133478309 -122.426409592351 (37.7846133478309, -122.426409592351) 13 9 11 28858 41
4313 105327 Significant Tree 6 Tree(s) :: 17 2051 03rd St 1 Back Yard : Yard Tree Private 2         Permit Number 771015 6015779.9 2106081.5 37.7637846705736 -122.388584622631 (37.7637846705736, -122.388584622631) 14 3 8 28856 29
7964 105328 Significant Tree 6 Tree(s) :: 17 2051 03rd St 2 Back Yard : Yard Tree Private 2         Permit Number 771015 6015779.9 2106081.5 37.7637846705736 -122.388584622631 (37.7637846705736, -122.388584622631) 14 3 8 28856 29
146644 105349 Significant Tree 6 Tree(s) :: 17 151X Spruce St 1 Front Yard : Yard Tree Private 2   01/16/2014 12:00:00 AM     Permit Number 771071 5997060.93638 2115845.70083 37.7895394616557 -122.45403267224 (37.7895394616557, -122.45403267224) 11 6 1 54 31
180419 105351 Significant Tree 6 Pyrus calleryana :: Ornamental Pear 44 2040 Jackson St 1 Front Yard : Yard Tree Private 2   01/16/2014 12:00:00 AM 3   Permit Number 769933 6004399.13095 2117053.27366 37.7932731788779 -122.428729419132 (37.7932731788779, -122.428729419132) 13 9 1 28858 27
108660 105368 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 180 CLIFFORD TER   Sidewalk: Curb side : Cutout Tree Private 2           5999283.1 2106587.2 37.7642451591147 -122.445678167683 (37.7642451591147, -122.445678167683) 15 5 5 29492 9
102398 105415 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1450X McAllister St 1 Front Yard : Yard Tree Private 2           6002220.78829 2111575.67932 37.7781095739995 -122.435874511445 (37.7781095739995, -122.435874511445) 15 5 11 29492 41
114223 105416 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1450X McAllister St 2 Front Yard : Yard Tree Private 2           6002220.78829 2111575.67932 37.7781095739995 -122.435874511445 (37.7781095739995, -122.435874511445) 15 5 11 29492 41
34055 105417 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1450X McAllister St 3 Front Yard : Yard Tree Private 2           6002220.78829 2111575.67932 37.7781095739995 -122.435874511445 (37.7781095739995, -122.435874511445) 15 5 11 29492 41
30591 105422 Significant Tree 6 Pinus radiata :: Monterey Pine 15 5827 DIAMOND HEIGHTS BLVD 1 Front Yard : Yard Tree Private 2     36     6000844.1 2096795.2 37.7374476811542 -122.439577108095 (37.7374476811542, -122.439577108095) 2 7 5 63 7
156485 105434 Significant Tree 6 Eriobotrya deflexa :: Bronze Loquat 8 4355 ANZA ST 1 Back Yard : Yard Tree Private 2     10     5985110.8 2111730.2 37.7775470387472 -122.495074662501 (37.7775470387472, -122.495074662501) 11 6 2 55 26
155656 105435 Significant Tree 6 Tree(s) :: 17 610 PARNASSUS AVE 1 Sidewalk: Property side : Yard Tree Private 2   03/05/2014 12:00:00 AM 16   Permit Number 771221 5995151.3 2106193.4 37.762927120329 -122.459940260935 (37.762927120329, -122.459940260935) 15 5 11 56 12
80420 105436 Significant Tree 6 Tree(s) :: 17 610 PARNASSUS AVE 7 Sidewalk: Property side : Yard Tree Private 2   03/05/2014 12:00:00 AM 15   Permit Number 771221 5995151.3 2106193.4 37.762927120329 -122.459940260935 (37.762927120329, -122.459940260935) 15 5 11 56 12
106429 105497 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3929 19TH ST 1 Front Yard : Yard Tree Private 2     60     6003450.9 2104734.8 37.7593959875427 -122.431130714429 (37.7593959875427, -122.431130714429) 2 4 5 28862 3
59764 105504 Significant Tree 6 Pinus radiata :: Monterey Pine 15 39 MAGELLAN AVE 1 Front Yard : Yard Tree Private 2     18     5994694.1 2101166.3 37.7490976851152 -122.461157135733 (37.7490976851152, -122.461157135733) 1 8 4 29491 40
112272 105540 Significant Tree 6 Myoporum laetum :: Myoporum 62 2694 47TH AVE 1 Front Yard : Yard Tree Private 2     12     5981878.3 2096771.8 37.7362857499502 -122.505147911282 (37.7362857499502, -122.505147911282) 1 8 3 29491 35
23877 105554 Significant Tree 6 Maytenus boaria :: Mayten 58 410 Elizabeth St 1 Front Yard : Yard Tree Private 2         Permit Number 772516 6003623.1 2102191.9 37.7524235434098 -122.430353733326 (37.7524235434098, -122.430353733326) 2 4 5 28862 22
46751 105555 Significant Tree 6 Maytenus boaria :: Mayten 58 410 Elizabeth St 2 Front Yard : Yard Tree Private 2         Permit Number 772516 6003623.1 2102191.9 37.7524235434098 -122.430353733326 (37.7524235434098, -122.430353733326) 2 4 5 28862 22
98635 105649 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990274.6 2090665.2 37.7200090188364 -122.475672946469 (37.7200090188364, -122.475672946469) 1 8 4 64 14
143592 105678 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 101X 03RD ST 2 Sidewalk: Curb side : Cutout Tree Private 2     10 4x4   6012079.1 2114345.8 37.7862707590298 -122.401965633825 (37.7862707590298, -122.401965633825) 12 2 9 28853 6
158054 105754 Significant Tree 6 Tree(s) :: 17 1899X Eddy St 2 Front Yard : Yard Tree Private 2   02/21/2014 12:00:00 AM     Permit Number 772599 6001374.8 2112478.6 37.7805406719806 -122.438865805362 (37.7805406719806, -122.438865805362) 15 5 11 29490 41
155662 105755 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1100X Divisadero St 1 Front Yard : Yard Tree Private 2           6001418 2112151 37.7796436231931 -122.438692875339 (37.7796436231931, -122.438692875339) 15 5 11 29490 41
50063 105765 Significant Tree 6 Pinus radiata :: Monterey Pine 15 95 ORA WAY 1 Front Yard : Yard Tree Private 2     18     6001454.9 2097857 37.7403978808149 -122.437541306682 (37.7403978808149, -122.437541306682) 2 7 5 63 7
34790 105768 Significant Tree 6 Pinus radiata :: Monterey Pine 15 98X GOLD MINE DR 3 Front Yard : Yard Tree Private 2     16     6001350 2099153 37.7439504273559 -122.437996817375 (37.7439504273559, -122.437996817375) 2 7 5 63 22
49649 105844 Significant Tree 6 Tree(s) :: 17 355 Buena Vista Ave   Front Yard : Yard Tree Private 2   03/03/2014 12:00:00 AM     Permit Number 771052 6000886.5 2107736.6 37.767492540377 -122.440214908068 (37.767492540377, -122.440214908068) 15 5 5 29492 3
157045 105845 Significant Tree 6 Pinus radiata :: Monterey Pine 15 355 Buena Vista Ave   Front Yard : Yard Tree Private 2           6000886.5 2107736.6 37.767492540377 -122.440214908068 (37.767492540377, -122.440214908068) 15 5 5 29492 3
156684 105850 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 44 MENDOSA AVE 1 Sidewalk: Property side : Yard Tree Private 2     100 6x15   5993395.1 2101192.7 37.7490953323683 -122.465650972372 (37.7490953323683, -122.465650972372) 1 8 4 29491 40
173080 105857 Significant Tree 6 Juniperus chinensis :: Juniper 113 1500X Valencia St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006259.2 2100711.5 37.7485076710609 -122.421132539956 (37.7485076710609, -122.421132539956) 2 4 5 28859 19
124470 105858 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1580 Valencia St 18 Front Yard : Yard Tree Private 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
159232 105859 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1580 Valencia St 18 Front Yard : Yard Tree Private 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
182948 105860 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3615-3623X Cesar Chavez St 1 Front Yard : Yard Tree Private 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
22846 105861 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3615-3623X Cesar Chavez St 2 Front Yard : Yard Tree Private 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
75419 105862 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3615-3623X Cesar Chavez St 3 Front Yard : Yard Tree Private 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
23771 105863 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3615-3623X Cesar Chavez St 4 Front Yard : Yard Tree Private 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
35675 105864 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3615-3623X Cesar Chavez St 5 Front Yard : Yard Tree Private 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
126862 105865 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3615-3623X Cesar Chavez St 6 Front Yard : Yard Tree Private 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
61885 105866 Significant Tree 6 Maytenus boaria :: Mayten 58 3555 Cesar Chavez St 1 Front Yard : Yard Tree Private 2           6006336.4 2100501.8 37.7479362343406 -122.420850697466 (37.7479362343406, -122.420850697466) 2 7 7 28859 2
76185 105867 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 3555 Cesar Chavez St 2 Front Yard : Yard Tree Private 2           6006336.4 2100501.8 37.7479362343406 -122.420850697466 (37.7479362343406, -122.420850697466) 2 7 7 28859 2
186539 105868 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 3555 Cesar Chavez St 3 Front Yard : Yard Tree Private 2           6006336.4 2100501.8 37.7479362343406 -122.420850697466 (37.7479362343406, -122.420850697466) 2 7 7 28859 2
73380 105869 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 3555 Cesar Chavez St 4 Front Yard : Yard Tree Private 2           6006336.4 2100501.8 37.7479362343406 -122.420850697466 (37.7479362343406, -122.420850697466) 2 7 7 28859 2
145596 105870 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 3555 Cesar Chavez St 5 Front Yard : Yard Tree Private 2           6006336.4 2100501.8 37.7479362343406 -122.420850697466 (37.7479362343406, -122.420850697466) 2 7 7 28859 2
178545 105871 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 3555 Cesar Chavez St 6 Front Yard : Yard Tree Private 2           6006336.4 2100501.8 37.7479362343406 -122.420850697466 (37.7479362343406, -122.420850697466) 2 7 7 28859 2
51024 105872 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 595X San Jose Ave 6 Front Yard : Yard Tree Private 2           6006124.47156 2100100.14306 37.7468214281195 -122.421555015777 (37.7468214281195, -122.421555015777) 2 7 7 28859 2
97021 105907 Significant Tree 6 Pinus Spp :: Pine Spp 100 1837 30TH AVE 1 Front Yard : Yard Tree Private 2     6     5986904 2102674 37.7527860393128 -122.488205804709 (37.7527860393128, -122.488205804709) 1 8 3 56 35
38818 105964 Significant Tree 6 Tree(s) :: 17 360 MISSOURI ST 1 Front Yard : Yard Tree Private 2           6013401.8 2105413.2 37.7618175880082 -122.396762946114 (37.7618175880082, -122.396762946114) 10 3 8 28856 29
125248 106038 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 230 Lakeview Ave   Front Yard : Yard Tree Private 2         Permit Number 772456 5997013.1 2089546.6 37.7173259605404 -122.452299707743 (37.7173259605404, -122.452299707743) 9 8 6 28861 24
111290 106058 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 301 FILBERT ST 1 Front Yard : Yard Tree Private 2     10     6011273 2120044 37.8018716248897 -122.405155936594 (37.8018716248897, -122.405155936594) 3 1 10 308 23
2008 106059 Significant Tree 6 Salix spp :: Willow 203 339 FILBERT ST 1 Front Yard : Yard Tree Private 2     6     6011263.6 2119947.8 37.801606957686 -122.405181687156 (37.801606957686, -122.405181687156) 3 1 10 308 23
9218 106080 Significant Tree 6 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 188 The Embarcadero 1 Front Yard : Yard Tree Private 2   03/20/2014 12:00:00 AM     Permit Number 771259 6015087.8131 2116516.98611 37.7923997963133 -122.391708043282 (37.7923997963133, -122.391708043282) 12 2 9 28855 6
188800 106107 Significant Tree 6 Magnolia champaca :: Champa 141 135 MENDOSA AVE 1 Sidewalk: Property side : Yard Tree Private 2   04/23/2014 12:00:00 AM     Permit Number 772704 5992893.2 2100790.2 37.747961208182 -122.467357269235 (37.747961208182, -122.467357269235) 1 8 4 29491 40
122278 106109 Significant Tree 6 Magnolia champaca :: Champa 141 135 MENDOSA AVE 2 Sidewalk: Property side : Yard Tree Private 2   04/23/2014 12:00:00 AM     Permit Number 772704 5992893.2 2100790.2 37.747961208182 -122.467357269235 (37.747961208182, -122.467357269235) 1 8 4 29491 40
179498 106172 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 150 CONRAD ST 1 Back Yard : Yard Tree Private 2     14     6001768.8 2096480 37.7366348009068 -122.436357440328 (37.7366348009068, -122.436357440328) 2 7 5 63 7
104435 106173 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 267 Green St 1 Front Yard : Yard Tree Private 2         Permit Number 771881 6011670.8 2119368.7 37.8000396459541 -122.403731811098 (37.8000396459541, -122.403731811098) 3 1 10 308 23
89112 106184 Significant Tree 6 Olea europaea :: Olive Tree 9 1327 ULLOA ST 1 Front Yard : Cutout Tree Private 2 FUF   2 4x4   5991893.8 2098371.4 37.7412620575898 -122.470636971077 (37.7412620575898, -122.470636971077) 1 8 4 59 40
187309 106198 Significant Tree 6 Juniperus scopulorum 'Pat :: Juniper Tree 'Pathfinder' 570 2101 42ND AVE 1 Front Yard : Yard Tree Private 2     18     5983206.1 2100796.8 37.7474153345648 -122.500854798087 (37.7474153345648, -122.500854798087) 1 8 3 29491 35
76095 106244 Significant Tree 6 Magnolia spp :: Magnolia 224 735 MANGELS AVE 1 Front Yard : Yard Tree Private 2   06/02/2014 12:00:00 AM 14   Permit Number 772876 5996640.8 2095225.8 37.7328983615352 -122.453996493912 (37.7328983615352, -122.453996493912) 9 7 4 59 40
192621 106250 Significant Tree 6 Tree(s) :: 17 580 De Haro St 1 Front Yard : Yard Tree Private 2         Permit Number 770844 6012025.9 2105717.4 37.7625761768628 -122.401543046462 (37.7625761768628, -122.401543046462) 8 3 8 28856 29
67194 106251 Significant Tree 6 Tree(s) :: 17 580 De Haro St 2 Front Yard : Yard Tree Private 2         Permit Number 770844 6012025.9 2105717.4 37.7625761768628 -122.401543046462 (37.7625761768628, -122.401543046462) 8 3 8 28856 29
81334 106255 Significant Tree 6 Tree(s) :: 17 1900X 18th St 1 Sidewalk: Property side : Yard Tree Private 2         Permit Number 770844 6012067 2105610 37.7622835736204 -122.401393347502 (37.7622835736204, -122.401393347502) 8 3 8 28856 29
181784 106310 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 99X Clearfield Dr 4 Sidewalk: Property side : Yard Tree Private 2   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.46484 37.7328958169551 -122.491498163849 (37.7328958169551, -122.491498163849) 1 8 4 64 35
81883 106311 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 99X Clearfield Dr 5 Sidewalk: Property side : Yard Tree Private 2   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.46484 37.7328958169551 -122.491498163849 (37.7328958169551, -122.491498163849) 1 8 4 64 35
22273 106336 Significant Tree 6 Pinus radiata :: Monterey Pine 15 112 EUGENIA AVE 1 Front Yard : Yard Tree Private 2     18     6006345.6 2098165.7 37.7415223501304 -122.420653072553 (37.7415223501304, -122.420653072553) 2 7 7 28859 2
82071 106360 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 1820 POST ST 1 Front Yard : Yard Tree Private 2     30     6003351.1 2114201.6 37.785383838011 -122.432151932321 (37.785383838011, -122.432151932321) 13 9 11 29490 13
22018 106361 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 1645 WEBSTER ST 2 Front Yard : Yard Tree Private 2     30     6003301.2 2114333.7 37.7857437219688 -122.432334009178 (37.7857437219688, -122.432334009178) 13 9 11 29490 13
109809 106362 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 1645 WEBSTER ST 1 Front Yard : Yard Tree Private 2     12     6003301.2 2114333.7 37.7857437219688 -122.432334009178 (37.7857437219688, -122.432334009178) 13 9 11 29490 13
120316 106363 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 101 URBANO DR 1 Front Yard : Yard Tree Private 2     80     5993535.8 2092458.1 37.7251204132224 -122.464530299025 (37.7251204132224, -122.464530299025) 9 8 4 59 40
28198 106364 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 155 BORICA ST 1 Front Yard : Yard Tree Private 2           5992696 2092292.5 37.7246172684066 -122.467421338179 (37.7246172684066, -122.467421338179) 9 8 4 59 40
171763 106405 Significant Tree 6 Pinus Spp :: Pine Spp 100 4849X 19th St   Front Yard : Yard Tree Private 2         Permit Number 772769 5999644.57626 2104777.09851 37.7592957011711 -122.444297841065 (37.7592957011711, -122.444297841065) 2 4 5 28862 3
82758 106514 Significant Tree 6 Tree(s) :: 17 190 EUCALYPTUS DR 2 Front Yard : Yard Tree Private 2           5990695.4 2094728.8 37.7311910349726 -122.474514801842 (37.7311910349726, -122.474514801842) 1 8 4 64 40

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);