trees
3,267 rows where qSpecies_id = 67 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
110227 | 9018 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5317 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5990428.6646 | 2112675.0185 | 37.7804511366409 | -122.476747631291 | (37.7804511366409, -122.476747631291) | 11 | 6 | 2 | 55 | 26 | |||
110443 | 9017 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5317 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5990440.4935 | 2112674.4808 | 37.7804503463948 | -122.476706670705 | (37.7804503463948, -122.476706670705) | 11 | 6 | 2 | 55 | 26 | |||
80084 | 9016 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5317 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5990445.3325 | 2112679.3199 | 37.7804639139017 | -122.476690284152 | (37.7804639139017, -122.476690284152) | 11 | 6 | 2 | 55 | 26 | |||
33340 | 9015 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5317 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5990451.7846 | 2112676.0938 | 37.7804554301667 | -122.476667727776 | (37.7804554301667, -122.476667727776) | 11 | 6 | 2 | 55 | 26 | |||
83230 | 9014 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5317 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5990456.086 | 2112679.8576 | 37.7804660140104 | -122.476653122424 | (37.7804660140104, -122.476653122424) | 11 | 6 | 2 | 55 | 26 | |||
153722 | 8994 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5200 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5990725.1914 | 2112685.5037 | 37.7804971216948 | -122.475722582279 | (37.7804971216948, -122.475722582279) | 11 | 6 | 2 | 54 | 26 | |||
114433 | 8993 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5200 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5990760.6778 | 2112689.8051 | 37.7805109894096 | -122.475600133516 | (37.7805109894096, -122.475600133516) | 11 | 6 | 2 | 54 | 26 | |||
120596 | 8961 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5000 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5991565.8879728 | 2112742.4953614 | 37.7807023086422 | -122.472818401074 | (37.7807023086422, -122.472818401074) | 11 | 6 | 2 | 54 | 26 | |||
141299 | 8960 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5000 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5991565.8879728 | 2112742.4953614 | 37.7807023086422 | -122.472818401074 | (37.7807023086422, -122.472818401074) | 11 | 6 | 2 | 54 | 26 | |||
70114 | 8959 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5000 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5991565.8879728 | 2112742.4953614 | 37.7807023086422 | -122.472818401074 | (37.7807023086422, -122.472818401074) | 11 | 6 | 2 | 54 | 26 | |||
182449 | 8958 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5000 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5991565.8879728 | 2112742.4953614 | 37.7807023086422 | -122.472818401074 | (37.7807023086422, -122.472818401074) | 11 | 6 | 2 | 54 | 26 | |||
152918 | 8957 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5000 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5991565.8879728 | 2112742.4953614 | 37.7807023086422 | -122.472818401074 | (37.7807023086422, -122.472818401074) | 11 | 6 | 2 | 54 | 26 | |||
86147 | 8956 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5000 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5991565.8879728 | 2112742.4953614 | 37.7807023086422 | -122.472818401074 | (37.7807023086422, -122.472818401074) | 11 | 6 | 2 | 54 | 26 | |||
107981 | 8955 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5000 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5991565.8879728 | 2112742.4953614 | 37.7807023086422 | -122.472818401074 | (37.7807023086422, -122.472818401074) | 11 | 6 | 2 | 54 | 26 | |||
58508 | 8948 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4800 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5992178.808881 | 2112763.6040387 | 37.780795730088 | -122.470699570025 | (37.780795730088, -122.470699570025) | 11 | 6 | 2 | 54 | 11 | |||
17168 | 8947 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4800 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5992178.808881 | 2112763.6040387 | 37.780795730088 | -122.470699570025 | (37.780795730088, -122.470699570025) | 11 | 6 | 2 | 54 | 11 | |||
187782 | 8946 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4800 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5992178.808881 | 2112763.6040387 | 37.780795730088 | -122.470699570025 | (37.780795730088, -122.470699570025) | 11 | 6 | 2 | 54 | 11 | |||
26606 | 8945 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4800 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5992178.808881 | 2112763.6040387 | 37.780795730088 | -122.470699570025 | (37.780795730088, -122.470699570025) | 11 | 6 | 2 | 54 | 11 | |||
77929 | 8943 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4800 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5992178.808881 | 2112763.6040387 | 37.780795730088 | -122.470699570025 | (37.780795730088, -122.470699570025) | 11 | 6 | 2 | 54 | 11 | |||
129726 | 8941 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4800 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5992178.808881 | 2112763.6040387 | 37.780795730088 | -122.470699570025 | (37.780795730088, -122.470699570025) | 11 | 6 | 2 | 54 | 11 | |||
151496 | 8936 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4630 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5992607.06001 | 2112810.29727 | 37.7809486924003 | -122.469221453946 | (37.7809486924003, -122.469221453946) | 11 | 6 | 2 | 54 | 11 | |||
52765 | 8933 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4600 Geary Blvd | 10 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5992801.3833857 | 2112786.477091 | 37.7808945155903 | -122.468547465827 | (37.7808945155903, -122.468547465827) | 11 | 6 | 2 | 54 | 11 | |||
181037 | 8932 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4600 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 12 | M6 | 5992801.3833857 | 2112786.477091 | 37.7808945155903 | -122.468547465827 | (37.7808945155903, -122.468547465827) | 11 | 6 | 2 | 54 | 11 | |||
127864 | 8931 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4600 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 12 | M6 | 5992801.3833857 | 2112786.477091 | 37.7808945155903 | -122.468547465827 | (37.7808945155903, -122.468547465827) | 11 | 6 | 2 | 54 | 11 | |||
169707 | 8930 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4600 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5992801.3833857 | 2112786.477091 | 37.7808945155903 | -122.468547465827 | (37.7808945155903, -122.468547465827) | 11 | 6 | 2 | 54 | 11 | |||
174843 | 8929 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4600 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5992801.3833857 | 2112786.477091 | 37.7808945155903 | -122.468547465827 | (37.7808945155903, -122.468547465827) | 11 | 6 | 2 | 54 | 11 | |||
102010 | 8928 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4600 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5992801.3833857 | 2112786.477091 | 37.7808945155903 | -122.468547465827 | (37.7808945155903, -122.468547465827) | 11 | 6 | 2 | 54 | 11 | |||
96046 | 8927 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4600 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 12 | M6 | 5992801.3833857 | 2112786.477091 | 37.7808945155903 | -122.468547465827 | (37.7808945155903, -122.468547465827) | 11 | 6 | 2 | 54 | 11 | |||
167422 | 8926 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4600 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5992801.3833857 | 2112786.477091 | 37.7808945155903 | -122.468547465827 | (37.7808945155903, -122.468547465827) | 11 | 6 | 2 | 54 | 11 | |||
87196 | 89041 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
60912 | 89040 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
128724 | 89039 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
146725 | 89038 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
152630 | 89037 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
21381 | 8899 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4400 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5993420.4630402 | 2112810.6467907 | 37.7809966203952 | -122.466407540491 | (37.7809966203952, -122.466407540491) | 11 | 6 | 2 | 54 | 11 | |||
115074 | 8898 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4400 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5993420.4630402 | 2112810.6467907 | 37.7809966203952 | -122.466407540491 | (37.7809966203952, -122.466407540491) | 11 | 6 | 2 | 54 | 11 | |||
193317 | 8897 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4400 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5993420.4630402 | 2112810.6467907 | 37.7809966203952 | -122.466407540491 | (37.7809966203952, -122.466407540491) | 11 | 6 | 2 | 54 | 11 | |||
139830 | 8886 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4200 Geary Blvd | 11 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5994040.3790539 | 2112832.2888332 | 37.7810917943038 | -122.464264532347 | (37.7810917943038, -122.464264532347) | 11 | 6 | 2 | 54 | 11 | |||
61422 | 8885 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4200 Geary Blvd | 10 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5994040.3790539 | 2112832.2888332 | 37.7810917943038 | -122.464264532347 | (37.7810917943038, -122.464264532347) | 11 | 6 | 2 | 54 | 11 | |||
71945 | 8884 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4200 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5994040.3790539 | 2112832.2888332 | 37.7810917943038 | -122.464264532347 | (37.7810917943038, -122.464264532347) | 11 | 6 | 2 | 54 | 11 | |||
119525 | 8883 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4200 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5994040.3790539 | 2112832.2888332 | 37.7810917943038 | -122.464264532347 | (37.7810917943038, -122.464264532347) | 11 | 6 | 2 | 54 | 11 | |||
81169 | 8882 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4200 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5994040.3790539 | 2112832.2888332 | 37.7810917943038 | -122.464264532347 | (37.7810917943038, -122.464264532347) | 11 | 6 | 2 | 54 | 11 | |||
131231 | 8881 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4200 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5994040.3790539 | 2112832.2888332 | 37.7810917943038 | -122.464264532347 | (37.7810917943038, -122.464264532347) | 11 | 6 | 2 | 54 | 11 | |||
52512 | 8880 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4200 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5994040.3790539 | 2112832.2888332 | 37.7810917943038 | -122.464264532347 | (37.7810917943038, -122.464264532347) | 11 | 6 | 2 | 54 | 11 | |||
145147 | 8879 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4200 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5994040.3790539 | 2112832.2888332 | 37.7810917943038 | -122.464264532347 | (37.7810917943038, -122.464264532347) | 11 | 6 | 2 | 54 | 11 | |||
112909 | 88718 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 301 WEBSTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774804 | 6004157.3 | 2109772.9 | 37.773269399945 | -122.429046849446 | (37.773269399945, -122.429046849446) | 7 | 9 | 11 | 29492 | 10 | |
38114 | 88717 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 301 WEBSTER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774804 | 6004157.3 | 2109772.9 | 37.773269399945 | -122.429046849446 | (37.773269399945, -122.429046849446) | 7 | 9 | 11 | 29492 | 10 | |
156478 | 88716 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 301 WEBSTER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2008 12:00:00 AM | 3x3 | Permit Number 774804 | 6004157.3 | 2109772.9 | 37.773269399945 | -122.429046849446 | (37.773269399945, -122.429046849446) | 7 | 9 | 11 | 29492 | 10 | ||
16202 | 8839 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4000 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 12 | M6 | 5994660.7719396 | 2112852.5225639 | 37.7811830898725 | -122.462119766821 | (37.7811830898725, -122.462119766821) | 11 | 6 | 2 | 54 | 11 | |||
53059 | 8838 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4000 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5994660.7719396 | 2112852.5225639 | 37.7811830898725 | -122.462119766821 | (37.7811830898725, -122.462119766821) | 11 | 6 | 2 | 54 | 11 | |||
85392 | 8837 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4000 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5994660.7719396 | 2112852.5225639 | 37.7811830898725 | -122.462119766821 | (37.7811830898725, -122.462119766821) | 11 | 6 | 2 | 54 | 11 | |||
7780 | 8836 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4000 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5994660.7719396 | 2112852.5225639 | 37.7811830898725 | -122.462119766821 | (37.7811830898725, -122.462119766821) | 11 | 6 | 2 | 54 | 11 | |||
135119 | 8835 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4000 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5994660.7719396 | 2112852.5225639 | 37.7811830898725 | -122.462119766821 | (37.7811830898725, -122.462119766821) | 11 | 6 | 2 | 54 | 11 | |||
192089 | 8834 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4000 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 12 | M6 | 5994660.7719396 | 2112852.5225639 | 37.7811830898725 | -122.462119766821 | (37.7811830898725, -122.462119766821) | 11 | 6 | 2 | 54 | 11 | |||
39723 | 8832 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4000 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 12 | M6 | 5994660.7719396 | 2112852.5225639 | 37.7811830898725 | -122.462119766821 | (37.7811830898725, -122.462119766821) | 11 | 6 | 2 | 54 | 11 | |||
138847 | 8831 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4000 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2000 12:00:00 AM | 3 | 3X3 | 5994592.55836 | 2112879.74247 | 37.7812539007276 | -122.462357725077 | (37.7812539007276, -122.462357725077) | 11 | 6 | 2 | 54 | 11 | ||
156742 | 8830 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4000 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1993 12:00:00 AM | 4 | 3x3 | 5994612.73133 | 2112879.86243 | 37.7812553917023 | -122.462287945756 | (37.7812553917023, -122.462287945756) | 11 | 6 | 2 | 54 | 11 | ||
13088 | 8817 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3800 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5995279.8386756 | 2112876.8357526 | 37.7812854712581 | -122.459979879431 | (37.7812854712581, -122.459979879431) | 11 | 6 | 2 | 54 | 11 | |||
140205 | 8816 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3800 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 12 | M6 | 5995279.8386756 | 2112876.8357526 | 37.7812854712581 | -122.459979879431 | (37.7812854712581, -122.459979879431) | 11 | 6 | 2 | 54 | 11 | |||
163878 | 8815 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3800 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5995279.8386756 | 2112876.8357526 | 37.7812854712581 | -122.459979879431 | (37.7812854712581, -122.459979879431) | 11 | 6 | 2 | 54 | 11 | |||
98428 | 8814 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3800 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5995279.8386756 | 2112876.8357526 | 37.7812854712581 | -122.459979879431 | (37.7812854712581, -122.459979879431) | 11 | 6 | 2 | 54 | 11 | |||
148139 | 8813 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3800 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5995279.8386756 | 2112876.8357526 | 37.7812854712581 | -122.459979879431 | (37.7812854712581, -122.459979879431) | 11 | 6 | 2 | 54 | 11 | |||
25629 | 8812 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3800 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5995279.8386756 | 2112876.8357526 | 37.7812854712581 | -122.459979879431 | (37.7812854712581, -122.459979879431) | 11 | 6 | 2 | 54 | 11 | |||
143835 | 8811 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3800 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 12 | M6 | 5995279.8386756 | 2112876.8357526 | 37.7812854712581 | -122.459979879431 | (37.7812854712581, -122.459979879431) | 11 | 6 | 2 | 54 | 11 | |||
138120 | 8810 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3800 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 12 | M6 | 5995279.8386756 | 2112876.8357526 | 37.7812854712581 | -122.459979879431 | (37.7812854712581, -122.459979879431) | 11 | 6 | 2 | 54 | 11 | |||
132836 | 87859 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 159 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50800 | 6000262.9 | 2104839.6 | 37.7595025728637 | -122.442163870481 | (37.7595025728637, -122.442163870481) | 2 | 4 | 5 | 28862 | 3 | ||
184175 | 87852 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1800X Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50759 | 6003483 | 2114899 | 37.7873061997009 | -122.431745409173 | (37.7873061997009, -122.431745409173) | 13 | 9 | 11 | 29490 | 27 | |
31210 | 8746 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3300 Geary Blvd | 11 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5996964.8998051 | 2112982.2523578 | 37.7816716864396 | -122.454158044121 | (37.7816716864396, -122.454158044121) | 11 | 6 | 1 | 54 | 31 | |||
51740 | 8745 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3300 Geary Blvd | 10 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5996964.8998051 | 2112982.2523578 | 37.7816716864396 | -122.454158044121 | (37.7816716864396, -122.454158044121) | 11 | 6 | 1 | 54 | 31 | |||
23457 | 8744 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3300 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5996964.8998051 | 2112982.2523578 | 37.7816716864396 | -122.454158044121 | (37.7816716864396, -122.454158044121) | 11 | 6 | 1 | 54 | 31 | |||
120162 | 8743 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3300 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5996964.8998051 | 2112982.2523578 | 37.7816716864396 | -122.454158044121 | (37.7816716864396, -122.454158044121) | 11 | 6 | 1 | 54 | 31 | |||
25501 | 8742 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3300 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5996964.8998051 | 2112982.2523578 | 37.7816716864396 | -122.454158044121 | (37.7816716864396, -122.454158044121) | 11 | 6 | 1 | 54 | 31 | |||
177324 | 8741 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3300 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5996964.8998051 | 2112982.2523578 | 37.7816716864396 | -122.454158044121 | (37.7816716864396, -122.454158044121) | 11 | 6 | 1 | 54 | 31 | |||
186923 | 8740 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3300 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5996964.8998051 | 2112982.2523578 | 37.7816716864396 | -122.454158044121 | (37.7816716864396, -122.454158044121) | 11 | 6 | 1 | 54 | 31 | |||
134156 | 8739 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3300 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5996964.8998051 | 2112982.2523578 | 37.7816716864396 | -122.454158044121 | (37.7816716864396, -122.454158044121) | 11 | 6 | 1 | 54 | 31 | |||
439 | 8729 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3200 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5997259.3218258 | 2113018.202003 | 37.7817872731337 | -122.453142084637 | (37.7817872731337, -122.453142084637) | 15 | 6 | 1 | 54 | 31 | |||
89472 | 8728 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3200 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5997259.3218258 | 2113018.202003 | 37.7817872731337 | -122.453142084637 | (37.7817872731337, -122.453142084637) | 15 | 6 | 1 | 54 | 31 | |||
90020 | 8727 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3200 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5997259.3218258 | 2113018.202003 | 37.7817872731337 | -122.453142084637 | (37.7817872731337, -122.453142084637) | 15 | 6 | 1 | 54 | 31 | |||
146145 | 8726 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3200 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5997259.3218258 | 2113018.202003 | 37.7817872731337 | -122.453142084637 | (37.7817872731337, -122.453142084637) | 15 | 6 | 1 | 54 | 31 | |||
127992 | 8725 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3200 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5997259.3218258 | 2113018.202003 | 37.7817872731337 | -122.453142084637 | (37.7817872731337, -122.453142084637) | 15 | 6 | 1 | 54 | 31 | |||
114326 | 8724 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3200 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5997259.3218258 | 2113018.202003 | 37.7817872731337 | -122.453142084637 | (37.7817872731337, -122.453142084637) | 15 | 6 | 1 | 54 | 31 | |||
28154 | 8723 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3200 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5997259.3218258 | 2113018.202003 | 37.7817872731337 | -122.453142084637 | (37.7817872731337, -122.453142084637) | 15 | 6 | 1 | 54 | 31 | |||
103006 | 8722 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3200 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5997259.3218258 | 2113018.202003 | 37.7817872731337 | -122.453142084637 | (37.7817872731337, -122.453142084637) | 15 | 6 | 1 | 54 | 31 | |||
103540 | 8721 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3200 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5997259.3218258 | 2113018.202003 | 37.7817872731337 | -122.453142084637 | (37.7817872731337, -122.453142084637) | 15 | 6 | 1 | 54 | 31 | |||
108217 | 87177 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1572 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50147 | 6014901.6694 | 2093877.1498 | 37.7302253707536 | -122.390769233 | (37.7302253707536, -122.390769233) | 10 | 3 | 8 | 58 | 1 | |
128454 | 8717 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3140 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5997420.69043 | 2113059.93694 | 37.7819111134077 | -122.452586840538 | (37.7819111134077, -122.452586840538) | 15 | 6 | 1 | 54 | 31 | |||
3051 | 8716 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3140 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5997420.69043 | 2113059.93694 | 37.7819111134077 | -122.452586840538 | (37.7819111134077, -122.452586840538) | 15 | 6 | 1 | 54 | 31 | |||
126178 | 8715 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3136 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5997354.19765 | 2113077.89785 | 37.7819566193322 | -122.452818170395 | (37.7819566193322, -122.452818170395) | 15 | 6 | 1 | 54 | 31 | |||
90575 | 8714 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3134 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5997363.0327 | 2113062.182 | 37.7819139740148 | -122.452786470687 | (37.7819139740148, -122.452786470687) | 15 | 6 | 1 | 54 | 31 | |||
142583 | 86958 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 80 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6000699 | 2098232 | 37.7413845365366 | -122.440181788906 | (37.7413845365366, -122.440181788906) | 2 | 7 | 5 | 63 | 7 | |||
16774 | 8683 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2900 Geary Blvd | 10 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5998150.0688375 | 2113145.5858248 | 37.7821880464461 | -122.450069715057 | (37.7821880464461, -122.450069715057) | 15 | 6 | 1 | 54 | 31 | |||
88544 | 8682 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2900 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5998150.0688375 | 2113145.5858248 | 37.7821880464461 | -122.450069715057 | (37.7821880464461, -122.450069715057) | 15 | 6 | 1 | 54 | 31 | |||
83819 | 8681 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2900 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5998150.0688375 | 2113145.5858248 | 37.7821880464461 | -122.450069715057 | (37.7821880464461, -122.450069715057) | 15 | 6 | 1 | 54 | 31 | |||
170095 | 8680 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2900 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5998150.0688375 | 2113145.5858248 | 37.7821880464461 | -122.450069715057 | (37.7821880464461, -122.450069715057) | 15 | 6 | 1 | 54 | 31 | |||
168924 | 8679 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2900 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5998150.0688375 | 2113145.5858248 | 37.7821880464461 | -122.450069715057 | (37.7821880464461, -122.450069715057) | 15 | 6 | 1 | 54 | 31 | |||
176995 | 8678 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2900 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5998150.0688375 | 2113145.5858248 | 37.7821880464461 | -122.450069715057 | (37.7821880464461, -122.450069715057) | 15 | 6 | 1 | 54 | 31 | |||
90795 | 8677 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2900 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5998150.0688375 | 2113145.5858248 | 37.7821880464461 | -122.450069715057 | (37.7821880464461, -122.450069715057) | 15 | 6 | 1 | 54 | 31 | |||
55955 | 8676 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2900 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5998150.0688375 | 2113145.5858248 | 37.7821880464461 | -122.450069715057 | (37.7821880464461, -122.450069715057) | 15 | 6 | 1 | 54 | 31 | |||
163250 | 86756 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3630 18th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49737 | 6005363 | 2105488 | 37.7615722645382 | -122.424571307751 | (37.7615722645382, -122.424571307751) | 8 | 4 | 5 | 28859 | 19 | |||
50571 | 8675 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2900 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5998150.0688375 | 2113145.5858248 | 37.7821880464461 | -122.450069715057 | (37.7821880464461, -122.450069715057) | 15 | 6 | 1 | 54 | 31 |
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) );