trees
45 rows where PlotSize = "Width 0ft" and qSpecies_id = 65 sorted by PlantType
This data as json, CSV (advanced)
These facets timed out: SiteOrder, PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
730 | 160454 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 11 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001177.46897 | 2090398.6691 | 37.7199032415307 | -122.437966457494 | (37.7199032415307, -122.437966457494) | 9 | 7 | 6 | 28861 | 5 | ||
3705 | 244981 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 200 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/31/2019 12:00:00 AM | 3 | Width 0ft | Permit Number 781995 | 6005180.5539 | 2109687.8318 | 37.7730936920725 | -122.425501217452 | (37.7730936920725, -122.425501217452) | 7 | 9 | 11 | 28852 | 10 |
5498 | 183675 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1274 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5984003.8455 | 2106504.9034 | 37.7631350020634 | -122.498517860637 | (37.7631350020634, -122.498517860637) | 1 | 8 | 3 | 56 | 35 | |||
6929 | 160451 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 99 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2020 12:00:00 AM | 3 | Width 0ft | 6001258.21118 | 2090347.83316 | 37.7197682487796 | -122.437683721428 | (37.7197682487796, -122.437683721428) | 9 | 7 | 6 | 28861 | 5 | ||
8169 | 160453 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 99 France Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2020 12:00:00 AM | 3 | Width 0ft | 6001205.1197 | 2090381.66789 | 37.7198581324333 | -122.437869661652 | (37.7198581324333, -122.437869661652) | 9 | 7 | 6 | 28861 | 5 | ||
9080 | 160643 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 556 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001401.85862 | 2090517.84189 | 37.7202432212254 | -122.437199350171 | (37.7202432212254, -122.437199350171) | 9 | 7 | 6 | 28861 | 5 | ||
12478 | 246193 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 755 Buena Vista Ave West | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2019 12:00:00 AM | 3 | Width 0ft | 5999885.5759 | 2108037.456 | 37.7682615787189 | -122.443698575802 | (37.7682615787189, -122.443698575802) | 15 | 5 | 11 | 29492 | 9 | ||
13377 | 160452 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 99 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2020 12:00:00 AM | 3 | Width 0ft | 6001241.76743 | 2090358.86031 | 37.719797591855 | -122.437741350891 | (37.719797591855, -122.437741350891) | 9 | 7 | 6 | 28861 | 5 | ||
13433 | 161215 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 800 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 0ft | 6003987.70302 | 2090927.51887 | 37.7215147582736 | -122.428290125502 | (37.7215147582736, -122.428290125502) | 9 | 7 | 6 | 28861 | 5 | ||
14927 | 262428 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 99 France Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6001205.1197 | 2090381.66789 | 37.7198581324333 | -122.437869661652 | (37.7198581324333, -122.437869661652) | 9 | 7 | 6 | 28861 | 5 | ||||
15492 | 262409 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 99 France Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2020 12:00:00 AM | 3 | Width 0ft | 6001205.1197 | 2090381.66789 | 37.7198581324333 | -122.437869661652 | (37.7198581324333, -122.437869661652) | 9 | 7 | 6 | 28861 | 5 | ||
16813 | 160908 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 615 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2019 12:00:00 AM | 3 | Width 0ft | 6002284.55838 | 2090317.50092 | 37.7197432674186 | -122.434133839205 | (37.7197432674186, -122.434133839205) | 9 | 7 | 6 | 28861 | 5 | |
18907 | 184945 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2000 41st Ave | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | FUF | 12/14/2019 12:00:00 AM | 3 | Width 0ft | 5983552 | 2101519 | 37.7494185989562 | -122.499712087956 | (37.7494185989562, -122.499712087956) | 1 | 8 | 3 | 29491 | 35 | |
19536 | 160455 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 11 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001161.40103 | 2090408.94535 | 37.719930544037 | -122.438022734371 | (37.719930544037, -122.438022734371) | 9 | 7 | 6 | 28861 | 5 | ||
27616 | 185641 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2100 Sunset Blvd | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985060.0587 | 2100441.1859 | 37.7465475916098 | -122.494417818871 | (37.7465475916098, -122.494417818871) | 1 | 8 | 3 | 29491 | 35 | |||
33220 | 139917 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1000 LAGUNA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6004809.1682 | 2112368.8803 | 37.7804342038606 | -122.426976875009 | (37.7804342038606, -122.426976875009) | 7 | 9 | 11 | 28852 | 41 | |||
33356 | 138630 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1702 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6000078.3648 | 2114795.7207 | 37.7868290426993 | -122.443517270296 | (37.7868290426993, -122.443517270296) | 13 | 6 | 1 | 29490 | 27 | |||
36626 | 245863 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 138 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781995 | 6005228.3599 | 2109588.7098 | 37.7728242280559 | -122.42532879528 | (37.7728242280559, -122.42532879528) | 7 | 9 | 11 | 28852 | 10 | |
39337 | 185946 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2001 Sunset Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984833.7396 | 2101513.2963 | 37.7494780662031 | -122.495279445201 | (37.7494780662031, -122.495279445201) | 1 | 8 | 3 | 29491 | 35 | |||
40098 | 182924 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2627 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5981795.9682 | 2097192.3992 | 37.7374357552632 | -122.505463727969 | (37.7374357552632, -122.505463727969) | 1 | 8 | 3 | 29491 | 35 | |||
92411 | 244965 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 250 Lily St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005276.5809 | 2110102.9361 | 37.7742388930949 | -122.42519859053 | (37.7742388930949, -122.42519859053) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
105717 | 185947 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2001 Sunset Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984831.6161 | 2101506.0763 | 37.7494581177315 | -122.495286255832 | (37.7494581177315, -122.495286255832) | 1 | 8 | 3 | 29491 | 35 | |||
107403 | 185945 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2001 Sunset Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984839.2608 | 2101514.9951 | 37.7494830539023 | -122.495260478283 | (37.7494830539023, -122.495260478283) | 1 | 8 | 3 | 29491 | 35 | |||
109884 | 183265 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1249 46th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5981784.0294 | 2106586.8909 | 37.7632296873576 | -122.506201404659 | (37.7632296873576, -122.506201404659) | 1 | 8 | 3 | 56 | 35 | |||
114225 | 185942 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2001 Sunset Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984826.9443 | 2101536.2304 | 37.7495406390981 | -122.495304634302 | (37.7495406390981, -122.495304634302) | 1 | 8 | 3 | 29491 | 35 | |||
116085 | 183630 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1451 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5982140.873 | 2105232.9073 | 37.7595330357482 | -122.504866885279 | (37.7595330357482, -122.504866885279) | 1 | 8 | 3 | 56 | 35 | |||
122875 | 184596 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1754 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983496.3685 | 2103208.1852 | 37.7540533675225 | -122.500029311717 | (37.7540533675225, -122.500029311717) | 1 | 8 | 3 | 56 | 35 | |||
125241 | 138631 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1704 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6000076.1375 | 2114809.8269 | 37.7868676476344 | -122.443525989893 | (37.7868676476344, -122.443525989893) | 13 | 6 | 1 | 29490 | 27 | |||
130358 | 247338 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 220 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6002315.9732 | 2109334.9211 | 37.7719624169971 | -122.435384903619 | (37.7719624169971, -122.435384903619) | 15 | 5 | 11 | 29492 | 9 | |||
133303 | 160893 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 634 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/2017 08:15:00 AM | 3 | Width 0ft | 6002406.55833 | 2090085.42086 | 37.7191129505803 | -122.433695551007 | (37.7191129505803, -122.433695551007) | 9 | 7 | 6 | 28861 | 5 | |
136814 | 184696 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1616 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5982844.9615 | 2104111.9169 | 37.7564965092336 | -122.502348875623 | (37.7564965092336, -122.502348875623) | 1 | 8 | 3 | 56 | 35 | |||
143006 | 161013 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 46 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781526 | 6004792.42669 | 2090835.59849 | 37.7213078665529 | -122.425501874617 | (37.7213078665529, -122.425501874617) | 9 | 7 | 6 | 28861 | 5 | |
146765 | 139915 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1000 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004816.1035 | 2112332.8828 | 37.7803357557587 | -122.426950318013 | (37.7803357557587, -122.426950318013) | 7 | 9 | 11 | 28852 | 41 | |||
155522 | 247495 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 537 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003124.7415 | 2110167.9221 | 37.7742955303854 | -122.432646828997 | (37.7742955303854, -122.432646828997) | 15 | 9 | 11 | 29492 | 10 | |||
156768 | 187082 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2600 Sunset Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 0ft | 5985191.6703 | 2096995.0278 | 37.737093071648 | -122.493708827707 | (37.737093071648, -122.493708827707) | 1 | 8 | 3 | 29491 | 35 | |||
162255 | 181649 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1265 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 5986124.6924 | 2106639.2388 | 37.7636279963988 | -122.491192553457 | (37.7636279963988, -122.491192553457) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
163287 | 160137 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 61 Seminole Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781533 | 5999114.78388 | 2090156.18461 | 37.7191199185408 | -122.445078994094 | (37.7191199185408, -122.445078994094) | 9 | 7 | 6 | 28861 | 25 | |
179876 | 181650 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1265 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5986125.2828 | 2106621.5286 | 37.7635794036098 | -122.49118920801 | (37.7635794036098, -122.49118920801) | 1 | 8 | 3 | 56 | 35 | |||
181596 | 140134 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1624 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5999973.0263 | 2110940.5311 | 37.7762376765447 | -122.443604667807 | (37.7762376765447, -122.443604667807) | 15 | 5 | 11 | 29492 | 16 | |||
183625 | 244227 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 332 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003264.0141 | 2109482.4208 | 37.7724212100587 | -122.43211609665 | (37.7724212100587, -122.43211609665) | 15 | 9 | 11 | 29492 | 10 | |||
184312 | 183416 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2685 22nd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5989557.6977 | 2097079.8204 | 37.7375803497092 | -122.478619864368 | (37.7375803497092, -122.478619864368) | 1 | 8 | 3 | 29491 | 35 | |||
185738 | 139916 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1000 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004814.4523 | 2112350.3862 | 37.7803837224117 | -122.426957277261 | (37.7803837224117, -122.426957277261) | 7 | 9 | 11 | 28852 | 41 | |||
186672 | 160894 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 642 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/2017 08:21:00 AM | 3 | Width 0ft | 6002380.66916 | 2090044.63219 | 37.7189994849067 | -122.433782126067 | (37.7189994849067, -122.433782126067) | 9 | 7 | 6 | 28861 | 5 |
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) );