trees
39,840 rows where qLegalStatus_id = 7 sorted by TreeID 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 178138 | 99997 | Permitted Site 7 | Corymbia maculata :: Spotted Gum 69 | 600@Clay Montgomery St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
| 60177 | 99996 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
| 175597 | 99994 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
| 84637 | 99993 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
| 179677 | 99992 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
| 5844 | 99991 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
| 167930 | 99988 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
| 183646 | 99975 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 2295 Folsom St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | ||||
| 111853 | 99974 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2295 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | ||||
| 3230 | 99973 | Permitted Site 7 | Corymbia maculata :: Spotted Gum 69 | 2295 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | ||||
| 39226 | 9997 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 120 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1997 12:00:00 AM | 18 | 2X2 | 6005389.5589835 | 2108331.2308198 | 37.7693805994769 | -122.424681718135 | (37.7693805994769, -122.424681718135) | 8 | 4 | 5 | 28853 | 19 | ||
| 107862 | 99964 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2439 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 769385 | 6003671 | 2116729 | 37.7923415699538 | -122.431225642925 | (37.7923415699538, -122.431225642925) | 13 | 9 | 1 | 29490 | 27 | ||||
| 131318 | 99947 | Permitted Site 7 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 522 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2012 12:00:00 AM | 4x4 | Permit Number 54785 | 6007824 | 2104880.2 | 37.7600420622217 | -122.416016646831 | (37.7600420622217, -122.416016646831) | 2 | 4 | 7 | 28859 | 19 | |
| 130683 | 99941 | Permitted Site 7 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 298 | 182 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 3x3 | Permit Number 769134 | 6003955.9 | 2092670 | 37.7262974264753 | -122.42852420031 | (37.7262974264753, -122.42852420031) | 9 | 7 | 6 | 28861 | 5 | ||
| 152098 | 99932 | Permitted Site 7 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 277 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2012 12:00:00 AM | 3x3 | Permit Number 768952 | 6006756.8 | 2104530.9 | 37.7590229060886 | -122.419682802567 | (37.7590229060886, -122.419682802567) | 2 | 4 | 7 | 28859 | 19 | ||
| 179365 | 99928 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3331 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 54787 | 6007298 | 2105556 | 37.7618680647923 | -122.417883738243 | (37.7618680647923, -122.417883738243) | 2 | 4 | 7 | 28859 | 19 |
| 50016 | 99924 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 125 Cerritos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2012 12:00:00 AM | Permit Number 769009 | 5992063.9 | 2092889.6 | 37.7262202448731 | -122.469649855245 | (37.7262202448731, -122.469649855245) | 9 | 8 | 4 | 59 | 40 | |||
| 102213 | 99920 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1740 Jones St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6008334 | 2118406 | 37.7972093435845 | -122.415210266144 | (37.7972093435845, -122.415210266144) | 5 | 1 | 10 | 308 | 21 | |||||
| 140038 | 99919 | Permitted Site 7 | Juniperus chinensis :: Juniper 113 | 1740 Jones St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6008334 | 2118406 | 37.7972093435845 | -122.415210266144 | (37.7972093435845, -122.415210266144) | 5 | 1 | 10 | 308 | 21 | |||||
| 103648 | 99918 | Permitted Site 7 | Juniperus chinensis :: Juniper 113 | 1740 Jones St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6008334 | 2118406 | 37.7972093435845 | -122.415210266144 | (37.7972093435845, -122.415210266144) | 5 | 1 | 10 | 308 | 21 | |||||
| 114624 | 99917 | Permitted Site 7 | Juniperus chinensis :: Juniper 113 | 1740 Jones St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6008334 | 2118406 | 37.7972093435845 | -122.415210266144 | (37.7972093435845, -122.415210266144) | 5 | 1 | 10 | 308 | 21 | |||||
| 118511 | 99916 | Permitted Site 7 | Juniperus chinensis :: Juniper 113 | 1740 Jones St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6008334 | 2118406 | 37.7972093435845 | -122.415210266144 | (37.7972093435845, -122.415210266144) | 5 | 1 | 10 | 308 | 21 | |||||
| 127896 | 99910 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 710 El Camino Del Mar | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2012 12:00:00 AM | Permit Number 769055 | 5986442 | 2114842 | 37.7861689922045 | -122.490698673964 | (37.7861689922045, -122.490698673964) | 11 | 6 | 1 | 55 | 33 | |||
| 22295 | 99908 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
| 184283 | 99907 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
| 189714 | 99906 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
| 156825 | 99905 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
| 101150 | 99904 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
| 14158 | 99903 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
| 53086 | 99902 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
| 23492 | 99901 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
| 119395 | 99900 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
| 148575 | 999 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1725 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | 6001467.99656 | 2092045.35722 | 37.7244411930178 | -122.437080040045 | (37.7244411930178, -122.437080040045) | 9 | 7 | 6 | 28861 | 25 | |||
| 189388 | 99899 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||
| 189259 | 99893 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 715 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997893.2 | 2108079.1 | 37.7682620848422 | -122.450592979377 | (37.7682620848422, -122.450592979377) | 15 | 5 | 11 | 29492 | 9 | |||||
| 97482 | 99892 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 5646@ Whipple Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.7109047702551 | -122.447663697002 | (37.7109047702551, -122.447663697002) | 9 | 7 | 6 | 28861 | 25 | ||
| 182794 | 99891 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 5646@ Whipple Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.7109047702551 | -122.447663697002 | (37.7109047702551, -122.447663697002) | 9 | 7 | 6 | 28861 | 25 | ||
| 118066 | 99890 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 5646@ Whipple Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.7109047702551 | -122.447663697002 | (37.7109047702551, -122.447663697002) | 9 | 7 | 6 | 28861 | 25 | ||
| 192701 | 99889 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 5646@ Whipple Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.7109047702551 | -122.447663697002 | (37.7109047702551, -122.447663697002) | 9 | 7 | 6 | 28861 | 25 | ||
| 80615 | 99888 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 5646 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.7109047702551 | -122.447663697002 | (37.7109047702551, -122.447663697002) | 9 | 7 | 6 | 28861 | 25 | ||
| 140023 | 99887 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 5646 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.7109047702551 | -122.447663697002 | (37.7109047702551, -122.447663697002) | 9 | 7 | 6 | 28861 | 25 | ||
| 171788 | 99880 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 248 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 768615 | 5999995.5 | 2091667 | 37.7233185016187 | -122.442143097817 | (37.7233185016187, -122.442143097817) | 9 | 7 | 6 | 28861 | 25 | ||
| 140555 | 99879 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 76 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | Permit Number 768149 | 6004987.5 | 2096139.2 | 37.7358814033012 | -122.425204756431 | (37.7358814033012, -122.425204756431) | 2 | 7 | 5 | 28859 | 2 | |||
| 73814 | 99874 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1301X San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 770597 | 6003616.3 | 2095455.7 | 37.7339271085192 | -122.429896797189 | (37.7339271085192, -122.429896797189) | 2 | 7 | 5 | 28861 | 25 |
| 188408 | 99873 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 194@Holloway Jules Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 20767 | 5994516.9 | 2091196.7 | 37.7217134214697 | -122.46104737723 | (37.7217134214697, -122.46104737723) | 9 | 8 | 6 | 28861 | 24 | ||||
| 50960 | 99872 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 194@Holloway Jules Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 20767 | 5994516.9 | 2091196.7 | 37.7217134214697 | -122.46104737723 | (37.7217134214697, -122.46104737723) | 9 | 8 | 6 | 28861 | 24 | ||||
| 146139 | 99871 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 194@Holloway Jules Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 20767 | 5994516.9 | 2091196.7 | 37.7217134214697 | -122.46104737723 | (37.7217134214697, -122.46104737723) | 9 | 8 | 6 | 28861 | 24 | ||||
| 25135 | 99865 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 566 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2012 12:00:00 AM | 3x3 | Permit Number 768884 | 5986943.1 | 2112080 | 37.7786145879683 | -122.488761926719 | (37.7786145879683, -122.488761926719) | 11 | 6 | 2 | 55 | 26 | ||
| 30463 | 99864 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 681 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768887 | 5981306.2 | 2111092.9 | 37.7755737343962 | -122.508188499048 | (37.7755737343962, -122.508188499048) | 11 | 6 | 2 | 55 | 26 | ||||
| 162549 | 99856 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2900 Baker St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768992 | 5999541.6 | 2118827.3 | 37.7978680691774 | -122.445664375651 | (37.7978680691774, -122.445664375651) | 13 | 9 | 1 | 57 | 17 | ||||
| 104052 | 99855 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2900 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768992 | 5999541.6 | 2118827.3 | 37.7978680691774 | -122.445664375651 | (37.7978680691774, -122.445664375651) | 13 | 9 | 1 | 57 | 17 | ||||
| 111262 | 99854 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 755 Marina Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x7 | Permit Number 768797 | 5999383.5 | 2121460.3 | 37.8050885512442 | -122.446400961387 | (37.8050885512442, -122.446400961387) | 13 | 9 | 1 | 57 | 17 | |||
| 23626 | 99853 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 755 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x12 | Permit Number 768797 | 5999383.5 | 2121460.3 | 37.8050885512442 | -122.446400961387 | (37.8050885512442, -122.446400961387) | 13 | 9 | 1 | 57 | 17 | |||
| 54866 | 99843 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 810 Judah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44828 | 5992070 | 2105943 | 37.7620618943588 | -122.470579074603 | (37.7620618943588, -122.470579074603) | 1 | 8 | 11 | 56 | 12 | ||||
| 25128 | 99842 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 810 Judah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44828 | 5992070 | 2105943 | 37.7620618943588 | -122.470579074603 | (37.7620618943588, -122.470579074603) | 1 | 8 | 11 | 56 | 12 | ||||
| 184220 | 99841 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 810 Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44828 | 5992070 | 2105943 | 37.7620618943588 | -122.470579074603 | (37.7620618943588, -122.470579074603) | 1 | 8 | 11 | 56 | 12 | ||||
| 171418 | 99840 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 810 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44828 | 5992070 | 2105943 | 37.7620618943588 | -122.470579074603 | (37.7620618943588, -122.470579074603) | 1 | 8 | 11 | 56 | 12 | ||||
| 59229 | 99839 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 | ||
| 26866 | 99838 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 | ||
| 134457 | 99837 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 | ||
| 50351 | 99836 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 | ||
| 122538 | 99835 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 | ||
| 5875 | 99834 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 | ||
| 152441 | 99822 | Permitted Site 7 | Tree(s) :: 17 | 1499X 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2012 12:00:00 AM | Permit Number 769141 | 5994283 | 2105334 | 37.7605174549789 | -122.462881035671 | (37.7605174549789, -122.462881035671) | 1 | 5 | 11 | 56 | 12 | |||
| 135010 | 99820 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 100X Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2012 12:00:00 AM | 8 | 3x3 | Permit Number 768974 | 6007364.7 | 2097747 | 37.7404300763526 | -122.417099703218 | (37.7404300763526, -122.417099703218) | 2 | 7 | 7 | 28859 | 2 |
| 4162 | 9982 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 660X Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X3 | 5999273.00844 | 2110518.1825 | 37.7750380665947 | -122.44599582765 | (37.7750380665947, -122.44599582765) | 15 | 5 | 11 | 29492 | 16 | |||
| 96540 | 99819 | Permitted Site 7 | Elaeocarpus decipiens :: Japanese Blueberry Tree 321 | 618 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2012 12:00:00 AM | 4 | 3x3 | Permit Number 768974 | 6007328.1 | 2097732.5 | 37.7403882035532 | -122.417225224725 | (37.7403882035532, -122.417225224725) | 2 | 7 | 7 | 28859 | 2 |
| 146392 | 9980 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 810X Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2011 12:00:00 AM | 24 | 3X3 | Permit Number 54082 | 6003050.1396073 | 2111037.6486225 | 37.7766793527515 | -122.432967039601 | (37.7766793527515, -122.432967039601) | 15 | 9 | 11 | 29492 | 10 | |
| 130885 | 9979 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 810X Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2011 12:00:00 AM | 12 | 3X3 | Permit Number 54081 | 6003050.1396073 | 2111037.6486225 | 37.7766793527515 | -122.432967039601 | (37.7766793527515, -122.432967039601) | 15 | 9 | 11 | 29492 | 10 | |
| 142216 | 99741 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2770 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2012 12:00:00 AM | 3x3 | Permit Number 768985 | 6000934 | 2116568 | 37.7917440216798 | -122.440684150501 | (37.7917440216798, -122.440684150501) | 13 | 6 | 1 | 29490 | 27 | ||
| 105736 | 99740 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2770 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2012 12:00:00 AM | 3x3 | Permit Number 768985 | 6000934 | 2116568 | 37.7917440216798 | -122.440684150501 | (37.7917440216798, -122.440684150501) | 13 | 6 | 1 | 29490 | 27 | ||
| 168672 | 9974 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 812X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003525.87553 | 2111110.58272 | 37.7769065842705 | -122.431326537326 | (37.7769065842705, -122.431326537326) | 7 | 9 | 11 | 29492 | 10 | |||
| 34019 | 99712 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Paloma Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | 9 | 8 | 4 | 59 | 40 | |||||
| 182177 | 99711 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Paloma Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | 9 | 8 | 4 | 59 | 40 | |||||
| 65809 | 99710 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Paloma Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | 9 | 8 | 4 | 59 | 40 | |||||
| 110354 | 99709 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Paloma Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | 9 | 8 | 4 | 59 | 40 | |||||
| 145661 | 99708 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Paloma Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | 9 | 8 | 4 | 59 | 40 | |||||
| 164649 | 99707 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100@Moncada Paloma Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | 9 | 8 | 4 | 59 | 40 | |||||
| 150596 | 99706 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100@Moncada Paloma Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | 9 | 8 | 4 | 59 | 40 | |||||
| 161672 | 99651 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1300 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | 3x3 | 5991764 | 2106610 | 37.7638756002396 | -122.471686009646 | (37.7638756002396, -122.471686009646) | 11 | 8 | 11 | 56 | 12 | |||
| 123281 | 99619 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 1590X Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2012 12:00:00 AM | 24 | 3x3 | Permit Number 768864 | 6006002.5 | 2118362.3 | 37.7969580495509 | -122.423274742897 | (37.7969580495509, -122.423274742897) | 13 | 9 | 10 | 28858 | 32 | |
| 111123 | 99618 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 1590X Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2012 12:00:00 AM | 24 | 3x3 | Permit Number 768864 | 6006002.5 | 2118362.3 | 37.7969580495509 | -122.423274742897 | (37.7969580495509, -122.423274742897) | 13 | 9 | 10 | 28858 | 32 | |
| 167244 | 99617 | Permitted Site 7 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 1590X Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2012 12:00:00 AM | 24 | 3x3 | Permit Number 768864 | 6006002.5 | 2118362.3 | 37.7969580495509 | -122.423274742897 | (37.7969580495509, -122.423274742897) | 13 | 9 | 10 | 28858 | 32 | |
| 88182 | 99608 | Permitted Site 7 | Tree(s) :: 17 | 1 Entrada Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 07/11/2012 12:00:00 AM | Permit Number 768939 | 5992743 | 2092489 | 37.7251595224946 | -122.467273147781 | (37.7251595224946, -122.467273147781) | 9 | 8 | 4 | 59 | 40 | |||
| 110931 | 99607 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 43709 | 6003513 | 2117956 | 37.7957016423098 | -122.431859976813 | (37.7957016423098, -122.431859976813) | 13 | 9 | 1 | 57 | 17 | |||
| 55998 | 99606 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43709 | 6003513 | 2117956 | 37.7957016423098 | -122.431859976813 | (37.7957016423098, -122.431859976813) | 13 | 9 | 1 | 57 | 17 | ||||
| 162472 | 99605 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43709 | 6003513 | 2117956 | 37.7957016423098 | -122.431859976813 | (37.7957016423098, -122.431859976813) | 13 | 9 | 1 | 57 | 17 | ||||
| 67682 | 99604 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 43709 | 6003513 | 2117956 | 37.7957016423098 | -122.431859976813 | (37.7957016423098, -122.431859976813) | 13 | 9 | 1 | 57 | 17 | |||
| 186647 | 99603 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 43709 | 6003513 | 2117956 | 37.7957016423098 | -122.431859976813 | (37.7957016423098, -122.431859976813) | 13 | 9 | 1 | 57 | 17 | |||
| 138494 | 99602 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 43709 | 6003513 | 2117956 | 37.7957016423098 | -122.431859976813 | (37.7957016423098, -122.431859976813) | 13 | 9 | 1 | 57 | 17 | |||
| 69659 | 99601 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 43709 | 6003513 | 2117956 | 37.7957016423098 | -122.431859976813 | (37.7957016423098, -122.431859976813) | 13 | 9 | 1 | 57 | 17 | |||
| 140113 | 99600 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 43709 | 6003513 | 2117956 | 37.7957016423098 | -122.431859976813 | (37.7957016423098, -122.431859976813) | 13 | 9 | 1 | 57 | 17 | |||
| 155994 | 99599 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43709 | 6003513 | 2117956 | 37.7957016423098 | -122.431859976813 | (37.7957016423098, -122.431859976813) | 13 | 9 | 1 | 57 | 17 | ||||
| 125315 | 99597 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3001@Filbert Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 17057 | 6002820 | 2118927.7 | 37.7983303693218 | -122.434327384023 | (37.7983303693218, -122.434327384023) | 13 | 9 | 1 | 57 | 17 | ||||
| 98718 | 99596 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3001@Filbert Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 17057 | 6002820 | 2118927.7 | 37.7983303693218 | -122.434327384023 | (37.7983303693218, -122.434327384023) | 13 | 9 | 1 | 57 | 17 | ||||
| 31122 | 99589 | Permitted Site 7 | Tree(s) :: 17 | 2299 Market St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002978.6 | 2106459.9 | 37.7641059209125 | -122.432887400675 | (37.7641059209125, -122.432887400675) | 15 | 4 | 5 | 28862 | 3 | |||||
| 85161 | 99588 | Permitted Site 7 | Tree(s) :: 17 | 2299 Market St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002978.6 | 2106459.9 | 37.7641059209125 | -122.432887400675 | (37.7641059209125, -122.432887400675) | 15 | 4 | 5 | 28862 | 3 | |||||
| 108527 | 99587 | Permitted Site 7 | Tree(s) :: 17 | 2299 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002978.6 | 2106459.9 | 37.7641059209125 | -122.432887400675 | (37.7641059209125, -122.432887400675) | 15 | 4 | 5 | 28862 | 3 | |||||
| 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 | |||||
| 105195 | 99584 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3599X 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2013 12:00:00 AM | 6003014.6 | 2106437.9 | 37.7640475560396 | -122.432761315556 | (37.7640475560396, -122.432761315556) | 15 | 4 | 5 | 28862 | 3 |
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) );