trees
163,064 rows where qCaretaker_id = 2 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24 | 264941 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Portola Dr | 12 | Median : Cutout | Tree | Private 2 | 3x3 | 5999749 | 2101261 | 37.7496473113918 | -122.443684097942 | (37.7496473113918, -122.443684097942) | 2 | 5 | 5 | 28862 | 38 | ||||
34 | 262408 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 66X Edgehill Way | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 5994840 | 2098758 | 37.7424934921887 | -122.46047813267 | (37.7424934921887, -122.46047813267) | 1 | 8 | 4 | 59 | 40 | ||||
43 | 264724 | DPW Maintained 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 2901 Broadway | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999656 | 2116990 | 37.7928298614365 | -122.445136362104 | (37.7928298614365, -122.445136362104) | 13 | 6 | 1 | 29490 | 27 | ||||
47 | 264965 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 951 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994993 | 2090257 | 37.7191606150529 | -122.45933361899 | (37.7191606150529, -122.45933361899) | 9 | 8 | 6 | 28861 | 24 | ||||
50 | 264964 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 3641 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 5996989 | 2114619 | 37.7861671437011 | -122.454192924446 | (37.7861671437011, -122.454192924446) | 11 | 6 | 1 | 54 | 31 | ||||
52 | 264970 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1026 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014048 | 2089990 | 37.7195046364539 | -122.393448574201 | (37.7195046364539, -122.393448574201) | 10 | 3 | 8 | 58 | 1 | ||||
53 | 264969 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 1099X Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15x15 | 6014337 | 2089983 | 37.719501468928 | -122.392449109694 | (37.719501468928, -122.392449109694) | 10 | 3 | 8 | 58 | 1 | |||
62 | 264980 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 222 Winfield St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6006740 | 2098205 | 37.7416524795013 | -122.419292156581 | (37.7416524795013, -122.419292156581) | 2 | 7 | 7 | 28859 | 2 | ||||
63 | 264975 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 445 Ortega St | 1 | Front Yard : Yard | Tree | Private 2 | 10x30 | 5992686 | 2102646 | 37.7530447932571 | -122.468208733714 | (37.7530447932571, -122.468208733714) | 1 | 8 | 4 | 56 | 12 | ||||
64 | 264974 | Significant Tree 6 | Persea americana :: Avocado 34 | 1868 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003954 | 2119422 | 37.7997518904289 | -122.430438688757 | (37.7997518904289, -122.430438688757) | 13 | 9 | 1 | 57 | 17 | ||||
68 | 264976 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 445 Ortega St | 2 | Front Yard : Yard | Tree | Private 2 | 10x30 | 5992686 | 2102646 | 37.7530447932571 | -122.468208733714 | (37.7530447932571, -122.468208733714) | 1 | 8 | 4 | 56 | 12 | ||||
74 | 106076 | Permitted Site 7 | Tree(s) :: 17 | 2500 Arelious Walker Dr | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 772788 | 6016510.6 | 2089868.7 | 37.7193080887588 | -122.384927739753 | (37.7193080887588, -122.384927739753) | 10 | 3 | 8 | 58 | 1 | ||||
75 | 74661 | Permitted Site 7 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 | 165-167 11th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52456 | 6007907.04639866 | 2109821.22082045 | 37.7736136206967 | -122.416079354056 | (37.7736136206967, -122.416079354056) | 8 | 2 | 9 | 28853 | 34 | ||
81 | 46536 | Permitted Site 7 | Tree(s) :: 17 | 73 Summer St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2002 12:00:00 AM | Permit Number 44686 | |||||||||||||
84 | 254457 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 43 | 1055X Duncan St | 2 | Side Yard : Yard | Tree | Private 2 | |||||||||||||||
95 | 261359 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007238 | 2095678 | 37.7347419306018 | -122.417391193891 | (37.7347419306018, -122.417391193891) | 2 | 7 | 7 | 28859 | 2 | ||||
97 | 261358 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2x Bache St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007175 | 2095707 | 37.7348180134015 | -122.417611061749 | (37.7348180134015, -122.417611061749) | 2 | 7 | 7 | 28859 | 2 | ||||
99 | 255073 | Private 9 | Tree(s) :: 17 | 173R Glenview Dr | Back Yard : Yard | Tree | Private 2 | ||||||||||||||||
103 | 253831 | DPW Maintained 1 | :: 45 | 699X Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | |||||||||||||
108 | 44866 | Permitted Site 7 | Tree(s) :: 17 | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
109 | 34921 | Permitted Site 7 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38517 | |||||||||||||||
110 | 45916 | Permitted Site 7 | Tree(s) :: 17 | 51 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
111 | 97355 | Permitted Site 7 | Tree(s) :: 17 | 5 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
112 | 33929 | Permitted Site 7 | Tree(s) :: 17 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/1997 12:00:00 AM | Permit Number 37893 | ||||||||||||||
115 | 121173 | Significant Tree 6 | Tree(s) :: 17 | 950 Duncan St | 2 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000333 | 2099683 | 37.7453477932295 | -122.441551386161 | (37.7453477932295, -122.441551386161) | 2 | 7 | 5 | 63 | 22 | ||||
116 | 113159 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 555 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005146 | 2111243 | 37.777361853017 | -122.425731455878 | (37.777361853017, -122.425731455878) | 7 | 9 | 11 | 28852 | 10 | ||||
117 | 108152 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2232 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003295.44003 | 2116396.66877 | 37.7914077834913 | -122.432501340527 | (37.7914077834913, -122.432501340527) | 13 | 9 | 1 | 29490 | 27 | |||||
126 | 173890 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2593 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989209 | 2097724 | 37.7393288482101 | -122.479872589648 | (37.7393288482101, -122.479872589648) | 1 | 8 | 3 | 29491 | 35 | ||||
128 | 110722 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1898X 10th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993137.43282 | 2102888.05903 | 37.753735486992 | -122.466665198088 | (37.753735486992, -122.466665198088) | 1 | 8 | 4 | 56 | 12 | |||||
131 | 109387 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 300X BAKER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000704 | 2110147 | 37.7741005029649 | -122.441019094263 | (37.7741005029649, -122.441019094263) | 15 | 5 | 11 | 29492 | 16 | ||||
135 | 99586 | Permitted Site 7 | Tree(s) :: 17 | 2299 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002978.6 | 2106459.9 | 37.7641059209125 | -122.432887400675 | (37.7641059209125, -122.432887400675) | 15 | 4 | 5 | 28862 | 3 | |||||
141 | 254165 | DPW Maintained 1 | :: 45 | 579 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5983759 | 2111886 | 37.7778955894485 | -122.499762435435 | (37.7778955894485, -122.499762435435) | 11 | 6 | 2 | 55 | 26 | ||||
143 | 251305 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1 Cashmere St | 4 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6017463 | 2095772 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | 10 | 3 | 8 | 58 | 1 | ||||
144 | 108797 | Undocumented 4 | :: 45 | 501-599 University St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |||||
148 | 108238 | Undocumented 4 | Tree(s) :: 17 | 764x JUNIPERO SERRA BLVD | 1 | Median : Yard | Tree | Private 2 | 5991289.6 | 2092496.8 | 37.7250969308873 | -122.472297921456 | (37.7250969308873, -122.472297921456) | 9 | 8 | 4 | 64 | 40 | |||||
157 | 114186 | Undocumented 4 | Shrub :: Shrub 66 | 2200 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997096 | 2109871 | 37.7731365175856 | -122.453479795748 | (37.7731365175856, -122.453479795748) | 15 | 5 | 2 | 29492 | 16 | ||||
158 | 100607 | Permitted Site 7 | Tree(s) :: 17 | 270x 05th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011410.5 | 2112131.8 | 37.7801542961347 | -122.404122955966 | (37.7801542961347, -122.404122955966) | 14 | 2 | 9 | 28853 | 34 | |||||
159 | 117627 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 890x VERMONT ST | 4 | Unaccepted Street : Yard | Tree | Private 2 | 6011292 | 2104239 | 37.7584758425658 | -122.403977311201 | (37.7584758425658, -122.403977311201) | 10 | 3 | 8 | 28856 | 29 | |||||
162 | 105806 | Undocumented 4 | Tree(s) :: 17 | 1248X ANZA ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x3 | 5994834 | 2112130 | 37.7792092085373 | -122.461468091676 | (37.7792092085373, -122.461468091676) | 11 | 6 | 2 | 54 | 11 | |||||
165 | 104843 | Permitted Site 7 | :: 45 | 1320 21st Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5989622 | 2106334.7 | 37.7629955389606 | -122.479074319647 | (37.7629955389606, -122.479074319647) | 1 | 8 | 3 | 56 | 35 | ||||||
169 | 258020 | DPW Maintained 1 | Tree(s) :: 17 | 1001X San Jose Ave | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6004855 | 2096548 | 37.7369963898236 | -122.425691948858 | (37.7369963898236, -122.425691948858) | 2 | 7 | 5 | 28859 | 2 | ||||
170 | 108637 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 15 TUCKER AVE | Back Yard : Yard | Tree | Private 2 | 6011049.2 | 2088423.2 | 37.7150354478954 | -122.403704200211 | (37.7150354478954, -122.403704200211) | 9 | 7 | 8 | 309 | 39 | ||||||
171 | 50655 | Permitted Site 7 | Tree(s) :: 17 | 430 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47238 | 6008643.36799877 | 2088325.11427356 | 37.7146314352433 | -122.412012884014 | (37.7146314352433, -122.412012884014) | 9 | 7 | 8 | 309 | 18 | ||||
174 | 113728 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 5 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
177 | 253253 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 99X Lopez Ave | 4 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | ||||
179 | 113995 | DPW Maintained 1 | :: 45 | 3221 Washington St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10/27/2015 12:00:00 AM | 39x3 | 5999265.7 | 2115942.6 | 37.789931692457 | -122.446411428366 | (37.789931692457, -122.446411428366) | 13 | 6 | 1 | 29490 | 31 | |||
183 | 253381 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 899 Waller St | 3 | Side Yard : Yard | Tree | Private 2 | 6001282 | 2108613 | 37.7699214264211 | -122.438909742148 | (37.7699214264211, -122.438909742148) | 15 | 5 | 5 | 29492 | 9 | |||||
188 | 112351 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 150 WEST PORTAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992711 | 2097652 | 37.7393339885882 | -122.467759098278 | (37.7393339885882, -122.467759098278) | 1 | 8 | 4 | 59 | 40 | ||||
193 | 100595 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
194 | 112359 | Undocumented 4 | Tree(s) :: 17 | 1129 DOUGLASS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001379 | 2100423 | 37.7474391957634 | -122.437987492815 | (37.7474391957634, -122.437987492815) | 2 | 4 | 5 | 63 | 22 | ||||
195 | 101535 | Permitted Site 7 | Tree(s) :: 17 | 1X Main St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46305 | 6014036.2 | 2116698.9 | 37.7928408582284 | -122.395359428861 | (37.7928408582284, -122.395359428861) | 12 | 2 | 9 | 28855 | 6 | ||||
197 | 104920 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 750 Gonzalez Dr | 1 | Median : Yard | Tree | Private 2 | 5990385 | 2090588 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | 1 | 8 | 4 | 64 | 14 | |||||
203 | 56596 | Permitted Site 7 | Tree(s) :: 17 | 536 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003173.97949504 | 2096124.55404861 | 37.7357385703685 | -122.431473765394 | (37.7357385703685, -122.431473765394) | 2 | 7 | 5 | 63 | 7 | |||||
205 | 61223 | Permitted Site 7 | Tree(s) :: 17 | 420 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1983 12:00:00 AM | Permit Number 21092 | 6011911.40369591 | 2116824.99897206 | 37.793068691891 | -122.402720238707 | (37.793068691891, -122.402720238707) | 4 | 1 | 10 | 28854 | 6 | |||
207 | 251656 | DPW Maintained 1 | Tree(s) :: 17 | 31x Malta Dr | 1 | unknown : Yard | Tree | Private 2 | 3x3 | 5999423 | 2096089 | 37.7354276387403 | -122.44443976141 | (37.7354276387403, -122.44443976141) | 9 | 7 | 4 | 63 | 40 | ||||
208 | 107457 | Undocumented 4 | Prunus spp :: Cherry 68 | 2682 16TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991487.4 | 2097177.7 | 37.7379609526954 | -122.471955163509 | (37.7379609526954, -122.471955163509) | 1 | 8 | 4 | 29491 | 40 | |||||
217 | 105438 | Undocumented 4 | :: 45 | 1116 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002483 | 2102334 | 37.7527490702591 | -122.434306541099 | (37.7527490702591, -122.434306541099) | 2 | 4 | 5 | 28862 | 22 | ||||
220 | 64608 | Permitted Site 7 | Tree(s) :: 17 | 2449 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/1988 12:00:00 AM | Permit Number 25511 | 6008240.06203716 | 2104170.72475134 | 37.75811738928 | -122.414527478763 | (37.75811738928, -122.414527478763) | 2 | 4 | 7 | 28859 | 19 | |||
222 | 59632 | Permitted Site 7 | Tree(s) :: 17 | 1726 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/1982 12:00:00 AM | Permit Number 19874 | 5999538.23629958 | 2110533.95574653 | 37.7750965176114 | -122.445079484139 | (37.7750965176114, -122.445079484139) | 15 | 5 | 11 | 29492 | 16 | |||
223 | 65500 | Permitted Site 7 | Tree(s) :: 17 | 5322 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/1989 12:00:00 AM | Permit Number 28384 | 5990524.68926015 | 2112731.41132738 | 37.7806115451711 | -122.47641956102 | (37.7806115451711, -122.47641956102) | 11 | 6 | 2 | 55 | 26 | |||
226 | 56655 | Permitted Site 7 | Tree(s) :: 17 | 491 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993749.22353597 | 2090472.28724098 | 37.7196801529508 | -122.463648462413 | (37.7196801529508, -122.463648462413) | 9 | 8 | 6 | 64 | 24 | |||||
227 | 102275 | Property Tree 8 | Tree(s) :: 17 | 267 Topaz Way | Back Yard : Yard | Landscaping | Private 2 | 6001225.6 | 2097744.2 | 37.7400751189117 | -122.438326054857 | (37.7400751189117, -122.438326054857) | 2 | 7 | 5 | 63 | 7 | ||||||
228 | 256437 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 3001 Sunset Blvd | 25 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
229 | 121402 | Undocumented 4 | :: 45 | 346X Duncan St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6004011 | 2099874 | 37.7460810947058 | -122.428847079389 | (37.7460810947058, -122.428847079389) | 2 | 7 | 5 | 63 | 22 | ||||
231 | 116978 | Undocumented 4 | Grevillea robusta :: Silk Oak Tree 76 | 111 BAY ST | 4 | Front Yard : Yard | Tree | Private 2 | 6010550 | 2121704 | 37.8063891294227 | -122.407774985143 | (37.8063891294227, -122.407774985143) | 3 | 1 | 10 | 308 | 23 | |||||
233 | 100684 | Undocumented 4 | Tree(s) :: 17 | 400 California St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6012367 | 2116823 | 37.7930886299645 | -122.401143699021 | (37.7930886299645, -122.401143699021) | 4 | 1 | 10 | 28854 | 6 | |||||
241 | 57687 | Permitted Site 7 | Tree(s) :: 17 | 4124 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/1976 12:00:00 AM | Permit Number 16590 | 6001721.25492757 | 2103540.26074256 | 37.7560179062476 | -122.437027141607 | (37.7560179062476, -122.437027141607) | 2 | 4 | 5 | 28862 | 3 | |||
251 | 187669 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 554 Valley St | 1 | Median : Yard | Tree | Private 2 | 6002324 | 2099197 | 37.7441265828549 | -122.434632098307 | (37.7441265828549, -122.434632098307) | 2 | 7 | 5 | 63 | 22 | |||||
256 | 254254 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 45X Everglade Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
257 | 115298 | Permitted Site 7 | :: 45 | 84 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992506.3 | 2098571.2 | 37.7418460572185 | -122.468533715231 | (37.7418460572185, -122.468533715231) | 1 | 8 | 4 | 29491 | 40 | |||||
260 | 56449 | Permitted Site 7 | Tree(s) :: 17 | 1439 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5982754.68200032 | 2105326.56088651 | 37.7598262733968 | -122.502750996927 | (37.7598262733968, -122.502750996927) | 1 | 8 | 3 | 56 | 35 | |||||
261 | 119280 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 95 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995293 | 2090512 | 37.7198780283713 | -122.458315087488 | (37.7198780283713, -122.458315087488) | 9 | 8 | 6 | 28861 | 24 | ||||
273 | 117070 | Private 9 | Tree(s) :: 17 | 6 JOY ST | 3 | Front Yard : Yard | Tree | Private 2 | 6010444 | 2098901 | 37.7437714571602 | -122.406533939617 | (37.7437714571602, -122.406533939617) | 2 | 7 | 7 | 28859 | 2 | |||||
277 | 110381 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 2235 PALOU AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27x18 | 6011689 | 2097713 | 37.740579036374 | -122.402145495204 | (37.740579036374, -122.402145495204) | 10 | 3 | 8 | 58 | 1 | ||||
294 | 53493 | Permitted Site 7 | Tree(s) :: 17 | 262 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1969 12:00:00 AM | Permit Number 6403 | 5992228.28376051 | 2089608.56362168 | 37.717220822263 | -122.468842940668 | (37.717220822263, -122.468842940668) | 9 | 8 | 6 | 64 | 24 | |||
299 | 116945 | Undocumented 4 | :: 45 | 3676 23RD ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005238 | 2102584 | 37.7535915013127 | -122.424797029407 | (37.7535915013127, -122.424797029407) | 2 | 4 | 5 | 28859 | 19 | ||||
301 | 108803 | Undocumented 4 | :: 45 | 401-499 University St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008323.15237 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | 9 | 3 | 7 | 309 | 28 | |||||
305 | 56460 | Permitted Site 7 | Tree(s) :: 17 | 2430 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006920.19744074 | 2104198.59660265 | 37.7581196808576 | -122.419094125211 | (37.7581196808576, -122.419094125211) | 2 | 4 | 7 | 28859 | 19 | |||||
307 | 99748 | Undocumented 4 | Tree(s) :: 17 | 4224 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002441 | 2100645 | 37.7481090922721 | -122.434331041256 | (37.7481090922721, -122.434331041256) | 2 | 4 | 5 | 28862 | 22 | ||||
308 | 102295 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1500 Michigan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6016449 | 2101073.5 | 37.7500708170088 | -122.385921283567 | (37.7500708170088, -122.385921283567) | 10 | 3 | 8 | 58 | 1 | ||||
309 | 40920 | Permitted Site 7 | Tree(s) :: 17 | 720 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.7846879743619 | -122.401028836502 | (37.7846879743619, -122.401028836502) | 12 | 2 | 9 | 28853 | 6 | |||
315 | 106681 | Undocumented 4 | Acer spp :: Maple 88 | 272 COLLINGWOOD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002031.2 | 2104270.9 | 37.7580416780136 | -122.436007529668 | (37.7580416780136, -122.436007529668) | 2 | 4 | 5 | 28862 | 3 | |||||
319 | 96811 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 356 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996379.5 | 2106960.2 | 37.7651031164685 | -122.455747798641 | (37.7651031164685, -122.455747798641) | 15 | 5 | 11 | 29492 | 12 | ||||
323 | 106136 | Undocumented 4 | Tree(s) :: 17 | 200X RIDGEWOOD AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996801 | 2094865 | 37.7319168756422 | -122.453416604011 | (37.7319168756422, -122.453416604011) | 9 | 7 | 4 | 59 | 40 | ||||
329 | 101063 | Undocumented 4 | Tree(s) :: 17 | 710 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001857 | 2102025 | 37.7518650783703 | -122.436449244442 | (37.7518650783703, -122.436449244442) | 2 | 4 | 5 | 28862 | 22 | ||||
333 | 44989 | Permitted Site 7 | Tree(s) :: 17 | 83 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
340 | 42995 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 436 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42871 | 6004515.16540478 | 2110012.02065503 | 37.7739462176361 | -122.42782598565 | (37.7739462176361, -122.42782598565) | 7 | 9 | 11 | 28852 | 10 | ||
346 | 251273 | DPW Maintained 1 | Acer negundo :: Box Elder 94 | 1301X 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993949 | 2106317 | 37.7631972735035 | -122.464107541423 | (37.7631972735035, -122.464107541423) | 1 | 5 | 11 | 56 | 12 | ||||
347 | 108327 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 86 11TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007396 | 2110315 | 37.7749406737789 | -122.417882154347 | (37.7749406737789, -122.417882154347) | 8 | 2 | 9 | 28853 | 19 | ||||
348 | 58983 | Permitted Site 7 | Tree(s) :: 17 | 585 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/1980 12:00:00 AM | Permit Number 18272 | 5995294.04081777 | 2111581.66432509 | 37.7777300922573 | -122.45983690137 | (37.7777300922573, -122.45983690137) | 11 | 6 | 2 | 54 | 11 | |||
349 | 253694 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 536 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005450 | 2111168 | 37.7771730951376 | -122.424674483112 | (37.7771730951376, -122.424674483112) | 7 | 9 | 11 | 28852 | 10 | ||||
350 | 119661 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 699x Missouri St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
359 | 113255 | Undocumented 4 | Tree(s) :: 17 | 178 Edgewood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5996632.6 | 2106029.8 | 37.7625629978497 | -122.454805165139 | (37.7625629978497, -122.454805165139) | 15 | 5 | 11 | 29492 | 12 | |||||
361 | 107141 | Undocumented 4 | Tree(s) :: 17 | 3498 16TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003565.7 | 2106565.7 | 37.764429704069 | -122.430864344516 | (37.764429704069, -122.430864344516) | 15 | 4 | 5 | 28862 | 3 | ||||||
364 | 255980 | Property Tree 8 | Tree(s) :: 17 | 541 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000551 | 2110847 | 37.7760138103106 | -122.441598590487 | (37.7760138103106, -122.441598590487) | 15 | 5 | 11 | 29492 | 16 | ||||
376 | 33627 | Permitted Site 7 | Tree(s) :: 17 | 315 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37728 | 6005028.27785393 | 2110030.93274628 | 37.7740271589488 | -122.426052389372 | (37.7740271589488, -122.426052389372) | 7 | 9 | 11 | 28852 | 10 | |||
382 | 34903 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
390 | 255918 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 80 Molimo Dr | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5998634.42423 | 2096706.77911 | 37.7370788872961 | -122.447210599537 | (37.7370788872961, -122.447210599537) | 9 | 7 | 4 | 59 | 40 | ||||
391 | 104857 | DPW Maintained 1 | :: 45 | 2555 46th Ave | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 5982069.8 | 2097707.6 | 37.7388664658919 | -122.504555139124 | (37.7388664658919, -122.504555139124) | 1 | 8 | 3 | 29491 | 35 | ||||||
392 | 108811 | Undocumented 4 | :: 45 | 301-399 University St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008160.40727 | 2092653.74948 | 37.7264898456848 | -122.413988233103 | (37.7264898456848, -122.413988233103) | 9 | 3 | 7 | 309 | 28 |
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) );