trees
50 rows where Zip Codes = 54 and qSpecies_id = 65 sorted by SiteOrder 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
193468 | 114082 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 20 Cook St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 5997500.7704 | 2113521.7588 | 37.7831837426404 | -122.452343137457 | (37.7831837426404, -122.452343137457) | 15 | 6 | 1 | 54 | 31 | |||
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 | |
88133 | 94732 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3965 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53863 | 5995732.51221 | 2115478.09158 | 37.7884538465346 | -122.458602225523 | (37.7884538465346, -122.458602225523) | 11 | 6 | 1 | 54 | 31 |
97742 | 141702 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 154 BEAUMONT AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5996846.4318 | 2111948.6051 | 37.7788267693983 | -122.454493192496 | (37.7788267693983, -122.454493192496) | 15 | 6 | 2 | 54 | 16 | |||
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 | ||||
101270 | 125542 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 65 Heather Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5997338.84626 | 2114106.78779 | 37.78478079984 | -122.452945569076 | (37.78478079984, -122.452945569076) | 15 | 6 | 1 | 54 | 31 | |||
137740 | 124329 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 122 Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995931.07902 | 2113567.14983 | 37.7832183231598 | -122.457776888478 | (37.7832183231598, -122.457776888478) | 11 | 6 | 1 | 54 | 31 | |||
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 | |||
163162 | 141448 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 194 Beaumont Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5996892.1188 | 2111627.1044 | 37.7779466329687 | -122.454311915058 | (37.7779466329687, -122.454311915058) | 15 | 6 | 2 | 54 | 16 | |||
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 | ||||
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 | |||
183389 | 36189 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 181 Parker Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/04/1998 12:00:00 AM | 11 | Permit Number 39257 | 5996904.302 | 2113169.9694 | 37.7821836328514 | -122.454381246555 | (37.7821836328514, -122.454381246555) | 11 | 6 | 1 | 54 | 31 | |
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 | |||
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 | |||
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 | |||
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 |
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 |
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 | |
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 | |
39037 | 124123 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 83 Stanyan Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 5996382.54086 | 2112452.81509 | 37.7801845808517 | -122.456134428556 | (37.7801845808517, -122.456134428556) | 11 | 6 | 2 | 54 | 16 | |||
64228 | 114566 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 633 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | Permit Number 774120 | 5997130.5 | 2113555.2 | 37.7832543439484 | -122.45362653243 | (37.7832543439484, -122.45362653243) | 11 | 6 | 1 | 54 | 31 | |||
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 | |
83852 | 67386 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 725 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1992 12:00:00 AM | Permit Number 30883 | 5991613.49950521 | 2110478.88524866 | 37.7744898098292 | -122.47248861667 | (37.7744898098292, -122.47248861667) | 11 | 6 | 2 | 54 | 26 | ||
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 | ||||
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 | |||
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 | |
105607 | 95918 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 682 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767617 | 5991324.67511 | 2110779.55477 | 37.7752986449747 | -122.473509641895 | (37.7752986449747, -122.473509641895) | 11 | 6 | 2 | 54 | 26 |
111637 | 37615 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 458 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | 13 | Permit Number 40039 | 5990633.38312 | 2112269.25863 | 37.779348904808 | -122.476009778191 | (37.779348904808, -122.476009778191) | 11 | 6 | 2 | 54 | 26 | |
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 | |
124027 | 124414 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 111 Cherry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 5996072.31903 | 2115814.16927 | 37.7893961490256 | -122.457450879091 | (37.7893961490256, -122.457450879091) | 11 | 6 | 1 | 54 | 31 | |||
127311 | 68456 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 107 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/1993 12:00:00 AM | 25 | Permit Number 32318 | 5991466.74972 | 2114692.79792 | 37.7860515606903 | -122.473303650104 | (37.7860515606903, -122.473303650104) | 11 | 6 | 2 | 54 | 26 | |
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 | |||
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 | |||
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 | |||
145859 | 122210 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 577 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991577.51719 | 2111532.45164 | 37.7773805333672 | -122.472689918421 | (37.7773805333672, -122.472689918421) | 11 | 6 | 2 | 54 | 26 | |||
147662 | 36190 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 181 Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/04/1998 12:00:00 AM | 8 | Permit Number 39257 | 5996902.2714 | 2113184.5215 | 37.7822234726194 | -122.454389322982 | (37.7822234726194, -122.454389322982) | 11 | 6 | 1 | 54 | 31 | |
152974 | 94731 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3965 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53863 | 5995713.23783 | 2115474.26613 | 37.788442235114 | -122.458668634362 | (37.788442235114, -122.458668634362) | 11 | 6 | 1 | 54 | 31 |
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 | |||
158169 | 37614 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 438 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | 21 | Permit Number 40038 | 5990631.22382 | 2112392.71042 | 37.7796877441109 | -122.476026266792 | (37.7796877441109, -122.476026266792) | 11 | 6 | 2 | 54 | 26 | |
165916 | 125541 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 65 Heather Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | 5997339.5515 | 2114115.46943 | 37.7848046777406 | -122.452943756065 | (37.7848046777406, -122.452943756065) | 15 | 6 | 1 | 54 | 31 | ||||
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 | ||||
174046 | 37616 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 462 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 17 | Permit Number 43442 | 5990631.36651 | 2112225.85325 | 37.7792296086918 | -122.476013583462 | (37.7792296086918, -122.476013583462) | 11 | 6 | 2 | 54 | 26 | |
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 | |||
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 |
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) );