trees
52 rows where qSpecies_id = 312 sorted by Fire Prevention Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7395 | 221186 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 2 Bird St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 5ft | 6005971.92074 | 2105741.10447 | 37.7623015995533 | -122.422483282201 | (37.7623015995533, -122.422483282201) | 8 | 4 | 5 | 28859 | 19 | |||
22683 | 86700 | Permitted Site 7 | Azara microphylla :: Little-Leaf Azara 312 | 306 Mullen Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010582.9 | 2099803.7 | 37.7462578450491 | -122.40611723741 | (37.7462578450491, -122.40611723741) | 2 | 7 | 7 | 28859 | 2 | ||||||
28017 | 86702 | Permitted Site 7 | Azara microphylla :: Little-Leaf Azara 312 | 306 Mullen Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/2007 12:00:00 AM | Permit Number 49696 | 6010582.9 | 2099803.7 | 37.7462578450491 | -122.40611723741 | (37.7462578450491, -122.40611723741) | 2 | 7 | 7 | 28859 | 2 | ||||
38761 | 86703 | Permitted Site 7 | Azara microphylla :: Little-Leaf Azara 312 | 306 Mullen Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/2007 12:00:00 AM | Permit Number 49696 | 6010582.9 | 2099803.7 | 37.7462578450491 | -122.40611723741 | (37.7462578450491, -122.40611723741) | 2 | 7 | 7 | 28859 | 2 | ||||
59000 | 247118 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 309 30th St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6004424.02289 | 2098368.69627 | 37.7419712447727 | -122.427311688289 | (37.7419712447727, -122.427311688289) | 2 | 7 | 5 | 63 | 7 | |||
62342 | 221190 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 306 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6010576.72766 | 2099825.02021 | 37.7463160404597 | -122.406140082515 | (37.7463160404597, -122.406140082515) | 2 | 7 | 7 | 28859 | 2 | |||
67716 | 86698 | Permitted Site 7 | Azara microphylla :: Little-Leaf Azara 312 | 306 Mullen Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49696 | 6010582.9 | 2099803.7 | 37.7462578450491 | -122.40611723741 | (37.7462578450491, -122.40611723741) | 2 | 7 | 7 | 28859 | 2 | |||||
77276 | 221188 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 306 Mullen Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6010586.52249 | 2099816.7363 | 37.7462938425051 | -122.40610562948 | (37.7462938425051, -122.40610562948) | 2 | 7 | 7 | 28859 | 2 | |||
98231 | 221187 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 306 Mullen Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6010600.71416 | 2099806.89287 | 37.7462676083603 | -122.4060558628 | (37.7462676083603, -122.4060558628) | 2 | 7 | 7 | 28859 | 2 | |||
102933 | 86699 | Permitted Site 7 | Azara microphylla :: Little-Leaf Azara 312 | 306 Mullen Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49696 | 6010582.9 | 2099803.7 | 37.7462578450491 | -122.40611723741 | (37.7462578450491, -122.40611723741) | 2 | 7 | 7 | 28859 | 2 | |||||
108901 | 86701 | Permitted Site 7 | Azara microphylla :: Little-Leaf Azara 312 | 306 Mullen Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/2007 12:00:00 AM | Permit Number 49696 | 6010582.9 | 2099803.7 | 37.7462578450491 | -122.40611723741 | (37.7462578450491, -122.40611723741) | 2 | 7 | 7 | 28859 | 2 | ||||
112830 | 221189 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 306 Mullen Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6010581.78695 | 2099819.77266 | 37.7463019148149 | -122.40612221837 | (37.7463019148149, -122.40612221837) | 2 | 7 | 7 | 28859 | 2 | |||
169565 | 86697 | Permitted Site 7 | Azara microphylla :: Little-Leaf Azara 312 | 306 Mullen Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49696 | 6010582.9 | 2099803.7 | 37.7462578450491 | -122.40611723741 | (37.7462578450491, -122.40611723741) | 2 | 7 | 7 | 28859 | 2 | |||||
183736 | 86704 | Permitted Site 7 | Azara microphylla :: Little-Leaf Azara 312 | 306 Mullen Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/2007 12:00:00 AM | Permit Number 49696 | 6010582.9 | 2099803.7 | 37.7462578450491 | -122.40611723741 | (37.7462578450491, -122.40611723741) | 2 | 7 | 7 | 28859 | 2 | ||||
38022 | 92650 | Permitted Site 7 | Azara microphylla :: Little-Leaf Azara 312 | 2201 Baker St | 16 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2009 12:00:00 AM | Permit Number 52915 | 5999814 | 2116396 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | 13 | 6 | 1 | 29490 | 27 | |||
39939 | 92648 | Permitted Site 7 | Azara microphylla :: Little-Leaf Azara 312 | 2201 Baker St | 14 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2009 12:00:00 AM | Permit Number 52915 | 5999814 | 2116396 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | 13 | 6 | 1 | 29490 | 27 | |||
43495 | 92649 | Permitted Site 7 | Azara microphylla :: Little-Leaf Azara 312 | 2201 Baker St | 15 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2009 12:00:00 AM | Permit Number 52915 | 5999814 | 2116396 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | 13 | 6 | 1 | 29490 | 27 | |||
44324 | 92655 | Permitted Site 7 | Azara microphylla :: Little-Leaf Azara 312 | 2201 Baker St | 21 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2009 12:00:00 AM | Permit Number 52915 | 5999814 | 2116396 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | 13 | 6 | 1 | 29490 | 27 | |||
59296 | 92651 | Permitted Site 7 | Azara microphylla :: Little-Leaf Azara 312 | 2201 Baker St | 17 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2009 12:00:00 AM | Permit Number 52915 | 5999814 | 2116396 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | 13 | 6 | 1 | 29490 | 27 | |||
76773 | 92652 | Permitted Site 7 | Azara microphylla :: Little-Leaf Azara 312 | 2201 Baker St | 18 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2009 12:00:00 AM | Permit Number 52915 | 5999814 | 2116396 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | 13 | 6 | 1 | 29490 | 27 | |||
106678 | 92654 | Permitted Site 7 | Azara microphylla :: Little-Leaf Azara 312 | 2201 Baker St | 20 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2009 12:00:00 AM | Permit Number 52915 | 5999814 | 2116396 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | 13 | 6 | 1 | 29490 | 27 | |||
119002 | 92656 | Permitted Site 7 | Azara microphylla :: Little-Leaf Azara 312 | 2201 Baker St | 22 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2009 12:00:00 AM | Permit Number 52915 | 5999814 | 2116396 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | 13 | 6 | 1 | 29490 | 27 | |||
154940 | 92653 | Permitted Site 7 | Azara microphylla :: Little-Leaf Azara 312 | 2201 Baker St | 19 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2009 12:00:00 AM | Permit Number 52915 | 5999814 | 2116396 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | 13 | 6 | 1 | 29490 | 27 | |||
175960 | 92657 | Permitted Site 7 | Azara microphylla :: Little-Leaf Azara 312 | 2201 Baker St | 23 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2009 12:00:00 AM | Permit Number 52915 | 5999814 | 2116396 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | 13 | 6 | 1 | 29490 | 27 | |||
62484 | 50772 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 101 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2004 12:00:00 AM | 10 | Permit Number 47303 | 5997008.23213 | 2115970.70815 | 37.7898796761415 | -122.454224055195 | (37.7898796761415, -122.454224055195) | 11 | 6 | 1 | 54 | 31 | ||
61744 | 188789 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 1634 Jerrold Ave | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 6015036.31186 | 2097273.47287 | 37.7395584527582 | -122.390540980997 | (37.7395584527582, -122.390540980997) | 10 | 3 | 8 | 58 | 1 | |||
67581 | 96620 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 525 Phelps St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 15 | 5x15 | Permit Number 48345 | 6015380.46656 | 2098080.19885 | 37.7417926430191 | -122.389407354988 | (37.7417926430191, -122.389407354988) | 10 | 3 | 8 | 58 | 1 | |
106906 | 188247 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 1634 Jerrold Ave | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 6015044.74579 | 2097267.17313 | 37.7395416228455 | -122.390511379801 | (37.7395416228455, -122.390511379801) | 10 | 3 | 8 | 58 | 1 | |||
122241 | 188246 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 1634 Jerrold Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 5ft | 6015049.72094 | 2097263.61753 | 37.7395321358953 | -122.390493929369 | (37.7395321358953, -122.390493929369) | 10 | 3 | 8 | 58 | 1 | |||
133705 | 188790 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 1698 Galvez Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 6015460.54799 | 2098007.46077 | 37.7415973588335 | -122.389125379738 | (37.7415973588335, -122.389125379738) | 10 | 3 | 8 | 58 | 1 | |||
168505 | 188248 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 1634 Jerrold Ave | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 6015039.58978 | 2097270.37702 | 37.7395501340363 | -122.390529431008 | (37.7395501340363, -122.390529431008) | 10 | 3 | 8 | 58 | 1 | |||
17718 | 256332 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 3000X Sunset Blvd | 11 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
21098 | 256335 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 3000X Sunset Blvd | 14 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
25366 | 256336 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 3000X Sunset Blvd | 15 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
34466 | 256344 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 3000X Sunset Blvd | 23 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
35197 | 256343 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 3000X Sunset Blvd | 22 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
35896 | 256331 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 3000X Sunset Blvd | 10 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
37391 | 256333 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 3000X Sunset Blvd | 12 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
62427 | 256345 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 3000X Sunset Blvd | 24 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
93011 | 256340 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 3000X Sunset Blvd | 19 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
93361 | 256334 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 3000X Sunset Blvd | 13 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
95473 | 256342 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 3000X Sunset Blvd | 21 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
107248 | 256337 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 3000X Sunset Blvd | 16 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
112703 | 256341 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 3000X Sunset Blvd | 20 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
113069 | 256329 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 3000X Sunset Blvd | 8 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
114519 | 256326 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 3000X Sunset Blvd | 5 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
140408 | 256339 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 3000X Sunset Blvd | 18 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
142838 | 256328 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 3000X Sunset Blvd | 7 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
148455 | 256325 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 3000X Sunset Blvd | 4 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
164752 | 256327 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 3000X Sunset Blvd | 6 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
164813 | 256330 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 3000X Sunset Blvd | 9 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
166888 | 256338 | DPW Maintained 1 | Azara microphylla :: Little-Leaf Azara 312 | 3000X Sunset Blvd | 17 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 |
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) );