trees

45 rows where PlotSize = "Width 0ft" and qSpecies_id = 65 sorted by PlotSize

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

PlotSize ✖

  • Width 0ft · 45 ✖
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

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)
);