trees

52 rows where qSpecies_id = 312

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▼ TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

Advanced export

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

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);