trees
28 rows where Neighborhoods (old) = 11 and qSpecies_id = 65 sorted by XCoord
This data as json, CSV (advanced)
qLegalStatus_id ✖
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30504 | 37659 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 486 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 16 | 3x3 | Permit Number 51139 | 5991909.24916 | 2112157.7974 | 37.7791167592266 | -122.471587940686 | (37.7791167592266, -122.471587940686) | 11 | 6 | 2 | 54 | 11 | |
98080 | 124074 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 701 Funston Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 5991915.64045 | 2110472.33987 | 37.7744893213305 | -122.471442985847 | (37.7744893213305, -122.471442985847) | 11 | 6 | 2 | 54 | 11 | ||||
103813 | 64171 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 610 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1987 12:00:00 AM | 21 | Permit Number 24952 | 5991942.3425 | 2111250.75611 | 37.7766281856646 | -122.471407349682 | (37.7766281856646, -122.471407349682) | 11 | 6 | 2 | 54 | 11 | |
120648 | 37604 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 775 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | 24 | Permit Number 40032 | 5992242.46027 | 2110184.69167 | 37.773718418011 | -122.470291511842 | (37.773718418011, -122.470291511842) | 11 | 6 | 2 | 54 | 11 | |
176460 | 124540 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1001 Balboa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5992434.91117 | 2111337.17059 | 37.7768939384148 | -122.469709718849 | (37.7768939384148, -122.469709718849) | 11 | 6 | 2 | 54 | 11 | |||
31089 | 124539 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1001 Balboa St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5992452.39614 | 2111338.25505 | 37.7768979266396 | -122.46964931253 | (37.7768979266396, -122.46964931253) | 11 | 6 | 2 | 54 | 11 | |||
97195 | 124538 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1001 Balboa St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5992462.99268 | 2111339.00328 | 37.7769005935172 | -122.469612710685 | (37.7769005935172, -122.469612710685) | 11 | 6 | 2 | 54 | 11 | |||
59428 | 124537 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1001 Balboa St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 5992475.11566 | 2111339.64129 | 37.7769030459693 | -122.469570820438 | (37.7769030459693, -122.469570820438) | 11 | 6 | 2 | 54 | 11 | |||
36087 | 67371 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1009 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1992 12:00:00 AM | 17 | Permit Number 30864 | 5992480.35304 | 2110659.61111 | 37.7750361697588 | -122.469503188985 | (37.7750361697588, -122.469503188985) | 11 | 6 | 2 | 54 | 11 | |
130777 | 90903 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 933 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 5992701.41821 | 2110665.49388 | 37.7750650957048 | -122.468738911315 | (37.7750650957048, -122.468738911315) | 11 | 6 | 2 | 54 | 11 | |||
190842 | 123821 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1851 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992885.6569 | 2112034.46491 | 37.7788345620747 | -122.468201203152 | (37.7788345620747, -122.468201203152) | 11 | 6 | 2 | 54 | 11 | |||
13852 | 64185 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1801 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1987 12:00:00 AM | 19 | 6x9 | Permit Number 24970 | 5993009.35743 | 2112040.64178 | 37.7788586655522 | -122.46777372724 | (37.7788586655522, -122.46777372724) | 11 | 6 | 2 | 54 | 11 |
181359 | 107593 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1801 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x6 | 5993030.37815 | 2112040.04561 | 37.7788582423825 | -122.467700965505 | (37.7788582423825, -122.467700965505) | 11 | 6 | 2 | 54 | 11 | |||
145252 | 123201 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1310 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5993108.25102 | 2112027.19449 | 37.7788274527304 | -122.467430639975 | (37.7788274527304, -122.467430639975) | 11 | 6 | 2 | 54 | 11 | |||
157703 | 123202 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1310 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5993110.48216 | 2112011.57103 | 37.7787846837447 | -122.467421785255 | (37.7787846837447, -122.467421785255) | 11 | 6 | 2 | 54 | 11 | |||
135740 | 112364 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 501X 09TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5993143 | 2111731 | 37.7780161887977 | -122.467288887933 | (37.7780161887977, -122.467288887933) | 11 | 6 | 2 | 54 | 11 | |||
172907 | 112365 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 501x 09TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993143 | 2111731 | 37.7780161887977 | -122.467288887933 | (37.7780161887977, -122.467288887933) | 11 | 6 | 2 | 54 | 11 | ||||
9355 | 43688 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 219 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 4 | 4x6 | Permit Number 43332 | 5993346.74324 | 2114008.67547 | 37.7842818271711 | -122.466749684627 | (37.7842818271711, -122.466749684627) | 11 | 6 | 2 | 54 | 11 |
102114 | 123272 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 550 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5993787.32117 | 2111737.84714 | 37.7780721632368 | -122.465060466509 | (37.7780721632368, -122.465060466509) | 11 | 6 | 2 | 54 | 11 | |||
143333 | 123274 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 590 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993793.96487 | 2111482.47797 | 37.7773713711806 | -122.465018932008 | (37.7773713711806, -122.465018932008) | 11 | 6 | 2 | 54 | 11 | |||
149788 | 105062 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 530 07th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 771082 | 5993803.2 | 2111872 | 37.7784414265163 | -122.465015282122 | (37.7784414265163, -122.465015282122) | 11 | 6 | 2 | 54 | 11 | ||||
162286 | 121320 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 550 07th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5993807 | 2111747 | 37.7780984292352 | -122.464993055827 | (37.7780984292352, -122.464993055827) | 11 | 6 | 2 | 54 | 11 | ||||
185139 | 114957 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 590 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2015 12:00:00 AM | Permit Number 770549 | 5993817 | 2111494.4 | 37.7774054340765 | -122.46494011266 | (37.7774054340765, -122.46494011266) | 11 | 6 | 2 | 54 | 11 | |||
17461 | 2783 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 424 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/17/2020 12:00:00 AM | 3 | 3X3 | Permit Number 785448 | 5994280.27723 | 2110781.18915 | 37.7754738485256 | -122.463285730589 | (37.7754738485256, -122.463285730589) | 11 | 6 | 2 | 54 | 11 | |
72547 | 102082 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 577 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/2009 12:00:00 AM | 3x3 | Permit Number 52510 | 5994678.1 | 2111611.2 | 37.7777757479831 | -122.461969778855 | (37.7777757479831, -122.461969778855) | 11 | 6 | 2 | 54 | 11 | |
175001 | 124270 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2 03rd Ave | 3 | Front Yard : Yard | Tree | Private 2 | 14 | 5994893.51688 | 2115041.88961 | 37.78720789934 | -122.461473360648 | (37.78720789934, -122.461473360648) | 11 | 6 | 1 | 54 | 11 | ||||
99540 | 124272 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2 03rd Ave | 1 | Front Yard : Yard | Tree | Private 2 | 14 | 5994894.05661 | 2114999.9706 | 37.787092832167 | -122.46146845316 | (37.787092832167, -122.46146845316) | 11 | 6 | 1 | 54 | 11 | ||||
173139 | 98032 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 132 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995145 | 2113574 | 37.783191941507 | -122.460496884135 | (37.783191941507, -122.460496884135) | 11 | 6 | 2 | 54 | 11 |
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) );