trees
416 rows where Police Districts = 8 and qLegalStatus_id = 6 sorted by PermitNotes 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194359 | 262298 | Significant Tree 6 | Tree(s) :: 17 | 1000X Mandalay Ln | 1 | Side Yard : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 10x10 | Permit Number 787936 | 5991616 | 2101838 | 37.7507643799851 | -122.471850083311 | (37.7507643799851, -122.471850083311) | 1 | 8 | 4 | 29491 | 12 | |
194270 | 264977 | Significant Tree 6 | Tree(s) :: 17 | 188 Yerba Buena Ave | 1 | Front Yard : Yard | Tree | Private 2 | 12/02/2020 12:00:00 AM | 3 | 3x3 | Permit Number 787864 | 5994639 | 2096200 | 37.7354582929988 | -122.460987765625 | (37.7354582929988, -122.460987765625) | 9 | 8 | 4 | 59 | 40 | |
10025 | 264885 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1279 44th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 787806 | 5982392 | 2106415 | 37.7627934961857 | -122.504085938563 | (37.7627934961857, -122.504085938563) | 1 | 8 | 3 | 56 | 35 | |||
1901 | 262254 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 4210 Ocean Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |||
6364 | 264920 | Significant Tree 6 | Tree(s) :: 17 | 99X Everglade Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 6x10 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |
7796 | 264921 | Significant Tree 6 | Tree(s) :: 17 | 99X Everglade Dr | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 6x10 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |
18983 | 262256 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4210 Ocean Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |||
11182 | 261019 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3450X 19th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784867 | 5990575 | 2092822 | 37.725948465298 | -122.47479191789 | (37.725948465298, -122.47479191789) | 9 | 8 | 4 | 64 | 14 | |||
4737 | 261021 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3440X 19th Ave | 2 | Back Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784857 | 5990714 | 2092679 | 37.7255638768787 | -122.474300978757 | (37.7255638768787, -122.474300978757) | 9 | 8 | 4 | 64 | 40 | |||
8965 | 261020 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3440X 19th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784857 | 5990714 | 2092679 | 37.7255638768787 | -122.474300978757 | (37.7255638768787, -122.474300978757) | 9 | 8 | 4 | 64 | 40 | |||
4096 | 261159 | Significant Tree 6 | Tree(s) :: 17 | 1100X Moraga St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/22/2020 12:00:00 AM | 3 | 10x10 | Permit Number 784837 | 5990881 | 2103853 | 37.7562544846391 | -122.474538790377 | (37.7562544846391, -122.474538790377) | 1 | 8 | 4 | 56 | 12 | |
6747 | 261157 | Significant Tree 6 | Tree(s) :: 17 | 1100X Moraga St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/22/2020 12:00:00 AM | 3 | 10x10 | Permit Number 784837 | 5990881 | 2103853 | 37.7562544846391 | -122.474538790377 | (37.7562544846391, -122.474538790377) | 1 | 8 | 4 | 56 | 12 | |
9381 | 261160 | Significant Tree 6 | Tree(s) :: 17 | 1100X Moraga St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/22/2020 12:00:00 AM | 3 | 10x10 | Permit Number 784837 | 5990881 | 2103853 | 37.7562544846391 | -122.474538790377 | (37.7562544846391, -122.474538790377) | 1 | 8 | 4 | 56 | 12 | |
11981 | 261158 | Significant Tree 6 | Juniperus californica :: California juniper 295 | 1100X Moraga St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | Permit Number 784837 | 5990881 | 2103853 | 37.7562544846391 | -122.474538790377 | (37.7562544846391, -122.474538790377) | 1 | 8 | 4 | 56 | 12 | |||
16055 | 260578 | Significant Tree 6 | Tree(s) :: 17 | 1879 Funston Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/22/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 784834 | 5992075.37659 | 2102679.56742 | 37.7531016753032 | -122.470322812874 | (37.7531016753032, -122.470322812874) | 1 | 8 | 4 | 56 | 12 | |
11391 | 260515 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 487 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | Permit Number 784711 | 5989595 | 2094714 | 37.7310865793073 | -122.478317956131 | (37.7310865793073, -122.478317956131) | 1 | 8 | 4 | 64 | 14 | |||
1002 | 260458 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 835 Darien Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/19/2019 12:00:00 AM | 3 | 6x10 | Permit Number 784514 | 5994066 | 2094094 | 37.7296427463027 | -122.462816092129 | (37.7296427463027, -122.462816092129) | 9 | 8 | 4 | 59 | 40 | |
6296 | 260461 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99X Lopez Ave | 4 | Front Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784513 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | |||
19246 | 253252 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99X Lopez Ave | 3 | Front Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784513 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | |||
797 | 260459 | Significant Tree 6 | Tree(s) :: 17 | 1798X Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | 5x10 | Permit Number 784470 | 5992678 | 2095461 | 37.733316146518 | -122.467713892437 | (37.733316146518, -122.467713892437) | 9 | 8 | 4 | 59 | 40 | |
748 | 259270 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
1038 | 259268 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
6044 | 259265 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
17333 | 259266 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
18957 | 259263 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
14608 | 259056 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 99 Cedro Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784357 | 5992279 | 2093128 | 37.7268872622364 | -122.468923614031 | (37.7268872622364, -122.468923614031) | 9 | 8 | 4 | 59 | 40 | |
821 | 261708 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 20 Entrada Ct | 1 | Front Yard : Yard | Tree | Private 2 | 02/21/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783258 | 5992481.8221 | 2092418.55282 | 37.724951011222 | -122.468170882637 | (37.724951011222, -122.468170882637) | 9 | 8 | 4 | 59 | 40 | |
12273 | 261709 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 20 Entrada Ct | 2 | Front Yard : Yard | Tree | Private 2 | 02/21/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783258 | 5992481.8221 | 2092418.55282 | 37.724951011222 | -122.468170882637 | (37.724951011222, -122.468170882637) | 9 | 8 | 4 | 59 | 40 | |
13120 | 258703 | Significant Tree 6 | Tree(s) :: 17 | 131X Juan Bautista Cir | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783241 | 5989556 | 2089774 | 37.7175203194228 | -122.478091750656 | (37.7175203194228, -122.478091750656) | 1 | 8 | 4 | 64 | 14 | |
15674 | 258702 | Significant Tree 6 | Tree(s) :: 17 | 131X Juan Bautista Cir | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783241 | 5989556 | 2089774 | 37.7175203194228 | -122.478091750656 | (37.7175203194228, -122.478091750656) | 1 | 8 | 4 | 64 | 14 | |
14866 | 259322 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 1721 19th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 11/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783194 | 5990247 | 2103661 | 37.7556905489205 | -122.476717329726 | (37.7556905489205, -122.476717329726) | 1 | 8 | 3 | 56 | 35 | |
194467 | 265133 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 2166 41st Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/11/2021 12:00:00 AM | 3 | 3x3 | Permit Number 783123 | 5983589.67085 | 2100408.11005 | 37.7463706120083 | -122.499499736486 | (37.7463706120083, -122.499499736486) | 1 | 8 | 3 | 29491 | 35 | |
126819 | 257966 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 35 | 98X Clearfield Dr | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 782748 | 5986022 | 2095487 | 37.7330009680725 | -122.490727117227 | (37.7330009680725, -122.490727117227) | 1 | 8 | 4 | 64 | 35 | |||
37232 | 256765 | Significant Tree 6 | Tree(s) :: 17 | 355 Serrano Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/15/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782555 | 5988732 | 2090042 | 37.7182083166364 | -122.480959519123 | (37.7182083166364, -122.480959519123) | 1 | 8 | 4 | 64 | 14 | |
137836 | 208971 | Significant Tree 6 | Tree(s) :: 17 | 150 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12/18/2018 12:00:00 AM | 3 | Width 6ft | Permit Number 782070 | 5994318.90627 | 2096521.25566 | 37.7363219572757 | -122.462117732164 | (37.7363219572757, -122.462117732164) | 9 | 8 | 4 | 59 | 40 | |
46153 | 209002 | Significant Tree 6 | Tree(s) :: 17 | 115 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/17/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781950 | 5994125 | 2096751 | 37.7369416119865 | -122.462804803775 | (37.7369416119865, -122.462804803775) | 9 | 8 | 4 | 59 | 40 | |
31720 | 254395 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1286 26th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 781556 | 5988061 | 2106558 | 37.7635178832746 | -122.484489596097 | (37.7635178832746, -122.484489596097) | 1 | 8 | 3 | 56 | 35 | |||
193743 | 211099 | Significant Tree 6 | Tree(s) :: 17 | 501 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/18/2018 12:00:00 AM | 3 | 10x10 | Permit Number 781418 | 5993137.63738 | 2096084.35497 | 37.7350542531473 | -122.466170096172 | (37.7350542531473, -122.466170096172) | 1 | 8 | 4 | 59 | 40 | |
95967 | 254201 | Significant Tree 6 | Tree(s) :: 17 | 55X Aerial Way | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 781191 | 5992360 | 2102538 | 37.7527294198072 | -122.469328234463 | (37.7527294198072, -122.469328234463) | 1 | 8 | 4 | 56 | 12 | |||
83312 | 254136 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1623 47th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10x6 | Permit Number 781075 | 5981544 | 2104016 | 37.7561566229771 | -122.506840869024 | (37.7561566229771, -122.506840869024) | 1 | 8 | 3 | 56 | 35 | |||
69013 | 254092 | Significant Tree 6 | Tree(s) :: 17 | 716 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 01/24/2018 12:00:00 AM | 3 | 10x10 | Permit Number 781051 | 5988732 | 2090042 | 37.7182083166364 | -122.480959519123 | (37.7182083166364, -122.480959519123) | 1 | 8 | 4 | 64 | 14 | |
114129 | 254093 | Significant Tree 6 | Tree(s) :: 17 | 716 Gonzalez Dr | 2 | Front Yard : Yard | Tree | Private 2 | 01/24/2018 12:00:00 AM | 3 | 10x10 | Permit Number 781051 | 5988732 | 2090042 | 37.7182083166364 | -122.480959519123 | (37.7182083166364, -122.480959519123) | 1 | 8 | 4 | 64 | 14 | |
20972 | 254094 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 320 Magellan Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 781012 | 5994209 | 2099943 | 37.7457108840866 | -122.462745872627 | (37.7457108840866, -122.462745872627) | 1 | 8 | 4 | 29491 | 40 | |||
52558 | 255280 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 320 Magellan Ave | 1 | Front Yard : Yard | Tree | Private 2 | 05/01/2018 12:00:00 AM | 3 | 10x20 | Permit Number 781012 | 5994287.14264 | 2099988.88368 | 37.7458413694018 | -122.462478996433 | (37.7458413694018, -122.462478996433) | 1 | 8 | 4 | 29491 | 40 | |
107089 | 255281 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 320 Magellan Ave | 2 | Front Yard : Yard | Tree | Private 2 | 05/01/2018 12:00:00 AM | 3 | 10x20 | Permit Number 781012 | 5994287.14264 | 2099988.88368 | 37.7458413694018 | -122.462478996433 | (37.7458413694018, -122.462478996433) | 1 | 8 | 4 | 29491 | 40 | |
111294 | 255282 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 320 Magellan Ave | 3 | Front Yard : Yard | Tree | Private 2 | 05/01/2018 12:00:00 AM | 3 | 10x20 | Permit Number 781012 | 5994287.14264 | 2099988.88368 | 37.7458413694018 | -122.462478996433 | (37.7458413694018, -122.462478996433) | 1 | 8 | 4 | 29491 | 40 | |
168382 | 255283 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 320 Magellan Ave | 4 | Front Yard : Yard | Tree | Private 2 | 05/01/2018 12:00:00 AM | 3 | 10x20 | Permit Number 781012 | 5994287.14264 | 2099988.88368 | 37.7458413694018 | -122.462478996433 | (37.7458413694018, -122.462478996433) | 1 | 8 | 4 | 29491 | 40 | |
123466 | 254110 | Significant Tree 6 | Tree(s) :: 17 | 100 Cerritos Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/04/2018 12:00:00 AM | 3 | 10x10 | Permit Number 781003 | 5992103 | 2092952 | 37.7263938396388 | -122.469519230239 | (37.7263938396388, -122.469519230239) | 9 | 8 | 4 | 59 | 40 | |
133059 | 253652 | Significant Tree 6 | Tree(s) :: 17 | 131 Font Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/20/2017 12:00:00 AM | 3 | 10x10 | Permit Number 780806 | 5990844 | 2088883 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | 1 | 8 | 4 | 64 | 14 | |
26477 | 253808 | Significant Tree 6 | Tree(s) :: 17 | 2 Garfield St | 2 | Side Yard : Yard | Tree | Private 2 | 09/14/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780744 | 5993976 | 2090624 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | 9 | 8 | 6 | 64 | 24 | |
69528 | 253807 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2 Garfield St | 1 | Side Yard : Yard | Tree | Private 2 | 10x2 | Permit Number 780744 | 5993976 | 2090624 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | 9 | 8 | 6 | 64 | 24 | |||
120070 | 253809 | Significant Tree 6 | Tree(s) :: 17 | 2 Garfield St | 3 | Side Yard : Yard | Tree | Private 2 | 09/14/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780744 | 5993976 | 2090624 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | 9 | 8 | 6 | 64 | 24 | |
159746 | 253286 | Significant Tree 6 | Tree(s) :: 17 | 40 Mendosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2017 12:00:00 AM | 3 | 6x10 | Permit Number 780599 | 5993445 | 2101187 | 37.7490825597194 | -122.465478005037 | (37.7490825597194, -122.465478005037) | 1 | 8 | 4 | 29491 | 40 | |
156060 | 253715 | Significant Tree 6 | Pseudotsuga menziesii :: Douglas Fir 285 | 2959 21st Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5x15 | Permit Number 780322 | 5989962 | 2095532 | 37.7333538971055 | -122.477108940264 | (37.7333538971055, -122.477108940264) | 1 | 8 | 4 | 64 | 35 | |||
94784 | 253250 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 99X Lopez Ave | 1 | Front Yard : Yard | Tree | Private 2 | 01/09/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780226 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | |
144280 | 253255 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 270 Castenada Ave | 2 | Front Yard : Yard | Tree | Private 2 | 01/09/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780226 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | |
188169 | 173629 | Significant Tree 6 | Tibochina urvilleana :: Princess Flower 154 | 10X Junipero Serra Blvd Off Ramp | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779383 | 5991168 | 2088425 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | 1 | 8 | 4 | 64 | 14 | |
73343 | 122634 | Significant Tree 6 | Tree(s) :: 17 | 3680X 19th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/05/2016 12:00:00 AM | 3 | 3x10 | Permit Number 779220 | 5990592 | 2091224 | 37.7215617409212 | -122.474616575991 | (37.7215617409212, -122.474616575991) | 9 | 8 | 4 | 64 | 40 | |
188643 | 122687 | Significant Tree 6 | Tree(s) :: 17 | 1462 Funston Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 01/04/2017 12:00:00 AM | 3 | 3x8 | Permit Number 779171 | 5992142.99696903 | 2105491.66018597 | 37.7608268551195 | -122.470293739312 | (37.7608268551195, -122.470293739312) | 1 | 8 | 4 | 56 | 12 | |
9908 | 215094 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 218 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994821.63014 | 2087784.20309 | 37.7123610457095 | -122.459746958272 | (37.7123610457095, -122.459746958272) | 9 | 8 | 6 | 28861 | 24 | |
81780 | 206842 | Significant Tree 6 | Tree(s) :: 17 | 218 Sadowa St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994803.1874 | 2087784.4983 | 37.712360795684 | -122.45981072288 | (37.712360795684, -122.45981072288) | 9 | 8 | 6 | 28861 | 24 | |
50856 | 1263 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/02/1998 12:00:00 AM | 10 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |
51080 | 120925 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
69574 | 1284 | Significant Tree 6 | Acer buergeranum :: Trident Maple 110 | 3995X Alemany Blvd | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12 | 3X10 | Permit Number 778829 | 5992111.48083 | 2087185.84409 | 37.7105618710011 | -122.469070448459 | (37.7105618710011, -122.469070448459) | 9 | 8 | 4 | 64 | 24 | ||
73917 | 120923 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
81897 | 120931 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 14 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
94421 | 120922 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
124817 | 120927 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 10 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
171046 | 120928 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 11 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
178015 | 120935 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 18 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
183804 | 121087 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 1443 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778784 | 5981521.32072 | 2105258.5458 | 37.7595669638281 | -122.507011468719 | (37.7595669638281, -122.507011468719) | 1 | 8 | 3 | 56 | 35 | |||
142152 | 117309 | Significant Tree 6 | Tree(s) :: 17 | 3711 19th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 06/06/2016 12:00:00 AM | 3 | 10x10 | Permit Number 777997 | 5990297.3 | 2090806 | 37.7203969366505 | -122.475604756889 | (37.7203969366505, -122.475604756889) | 1 | 8 | 4 | 64 | 14 | |
120116 | 116009 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 199x SAN BUENAVENTURA WAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777954 | 5993547 | 2095667 | 37.7339319096844 | -122.464724497297 | (37.7339319096844, -122.464724497297) | 9 | 8 | 4 | 59 | 40 | |
1773 | 116537 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 6 | Back Yard : Yard | Tree | Private 2 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754 | 2090179 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | 9 | 8 | 6 | 28861 | 24 | |
84393 | 116534 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 3 | Back Yard : Yard | Tree | Private 2 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754 | 2090179 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | 9 | 8 | 6 | 28861 | 24 | |
105492 | 116536 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 5 | Back Yard : Yard | Tree | Private 2 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754 | 2090179 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | 9 | 8 | 6 | 28861 | 24 | |
143694 | 116535 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 4 | Back Yard : Yard | Tree | Private 2 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754 | 2090179 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | 9 | 8 | 6 | 28861 | 24 | |
52054 | 255462 | Significant Tree 6 | Tree(s) :: 17 | 98 Saint Francis Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/2018 12:00:00 AM | 3 | 10x5 | Permit Number 777805 | 5992112.53458 | 2095987.97644 | 37.7347304251367 | -122.469707196177 | (37.7347304251367, -122.469707196177) | 9 | 8 | 4 | 59 | 40 | |
82975 | 255461 | Significant Tree 6 | Tree(s) :: 17 | 37 Santa Paula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/2018 12:00:00 AM | 3 | 10x6 | Permit Number 777804 | 5994021.13024 | 2097608.02637 | 37.7392888101295 | -122.463226093964 | (37.7392888101295, -122.463226093964) | 1 | 8 | 4 | 59 | 40 | |
92153 | 117518 | Significant Tree 6 | Ulmus americana :: American Elm 74 | 30 Santa Paula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2016 12:00:00 AM | 3 | Permit Number 777803 | 5993995.8 | 2097679.6 | 37.7394838741894 | -122.463318866351 | (37.7394838741894, -122.463318866351) | 1 | 8 | 4 | 59 | 40 | ||
63542 | 116459 | Significant Tree 6 | Eucalyptus lehmanni :: Bushy Yate 260 | 777 Brotherhood Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 10x20 | Permit Number 777772 | 5989848.42836 | 2088633.83291 | 37.7144066723949 | -122.476997704287 | (37.7144066723949, -122.476997704287) | 1 | 8 | 4 | 64 | 14 | ||
155480 | 116958 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 10x Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2016 12:00:00 AM | 3 | Permit Number 777762 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
92919 | 115827 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 60X CHUMASERO DR | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777531 | 5990913 | 2088468 | 37.714013037331 | -122.473306070941 | (37.714013037331, -122.473306070941) | 1 | 8 | 4 | 64 | 14 | |
21303 | 115100 | Significant Tree 6 | Tree(s) :: 17 | 710 PACHECO ST | 1 | Front Yard : Cutout | Tree | Private 2 | 02/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777305 | 5992727 | 2102215 | 37.7518637464828 | -122.468035600741 | (37.7518637464828, -122.468035600741) | 1 | 8 | 4 | 29491 | 12 | |
185127 | 116345 | Significant Tree 6 | Tree(s) :: 17 | 85x SANTA CLARA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777165 | 5993361 | 2096925 | 37.7373753392635 | -122.465458906558 | (37.7373753392635, -122.465458906558) | 1 | 8 | 4 | 59 | 40 | |
117265 | 116346 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 121 SAN BENITO WAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777164 | 5992901 | 2095856 | 37.7344135917102 | -122.466971633047 | (37.7344135917102, -122.466971633047) | 9 | 8 | 4 | 59 | 40 | |
116051 | 115752 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 100 Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | 9 | 8 | 4 | 59 | 40 | ||
177311 | 115751 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 100 Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | 9 | 8 | 4 | 59 | 40 | ||
83163 | 115737 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 9x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776557 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
96718 | 115731 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 15 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776556 | 5993468.8 | 2097225 | 37.7382052810266 | -122.465107977902 | (37.7382052810266, -122.465107977902) | 1 | 8 | 4 | 59 | 40 | ||
188463 | 115734 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 55 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 776555 | 5993732.7 | 2097034 | 37.7376960566374 | -122.464181687663 | (37.7376960566374, -122.464181687663) | 1 | 8 | 4 | 59 | 40 | ||||
193868 | 115735 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 57 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776554 | 5993777.6 | 2097002.8 | 37.7376129769989 | -122.464024183823 | (37.7376129769989, -122.464024183823) | 1 | 8 | 4 | 59 | 40 | ||
182457 | 115738 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 95x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776553 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
179132 | 115753 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 135x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776552 | 5994185.89401 | 2096656.23912 | 37.7366849291808 | -122.46258739592 | (37.7366849291808, -122.46258739592) | 9 | 8 | 4 | 59 | 40 | ||
54288 | 115736 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 66 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776551 | 5993801.4 | 2096894.7 | 37.7373175329251 | -122.463934052027 | (37.7373175329251, -122.463934052027) | 1 | 8 | 4 | 59 | 40 | ||
139444 | 115733 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 50 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776548 | 5993693.2 | 2096969 | 37.7375153061033 | -122.464313539267 | (37.7375153061033, -122.464313539267) | 1 | 8 | 4 | 59 | 40 | ||
149763 | 112290 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 34 YERBA BUENA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776546 | 5993584 | 2097045 | 37.7377176881769 | -122.464696609393 | (37.7377176881769, -122.464696609393) | 1 | 8 | 4 | 59 | 40 | |
71364 | 115730 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 10x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776540 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
73267 | 115729 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 10x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 776540 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | |||
85339 | 115176 | Significant Tree 6 | Tree(s) :: 17 | 460 Pacheco St | 1 | Front Yard : Yard | Tree | Private 2 | 01/14/2016 12:00:00 AM | 10x10 | Permit Number 775764 | 5993727.4 | 2101897.6 | 37.7510499693469 | -122.464553061226 | (37.7510499693469, -122.464553061226) | 1 | 8 | 4 | 29491 | 12 |
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) );