trees
133 rows where qSpecies_id = 66 sorted by YCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
150789 | 99672 | DPW Maintained 1 | Shrub :: Shrub 66 | 1250X Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
35821 | 93164 | DPW Maintained 1 | Shrub :: Shrub 66 | 201 Upper Ter | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/22/2009 12:00:00 AM | 1x2 | 5999670.5 | 2106448.3 | 37.7638858848202 | -122.444328283325 | (37.7638858848202, -122.444328283325) | 15 | 5 | 5 | 29492 | 3 | |||
133338 | 93163 | DPW Maintained 1 | Shrub :: Shrub 66 | 201 Upper Ter | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/22/2009 12:00:00 AM | 1x15 | 5999670.5 | 2106448.3 | 37.7638858848202 | -122.444328283325 | (37.7638858848202, -122.444328283325) | 15 | 5 | 5 | 29492 | 3 | |||
3033 | 121390 | Undocumented 4 | Shrub :: Shrub 66 | 1301x 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993851 | 2106604 | 37.7639796518152 | -122.464467327674 | (37.7639796518152, -122.464467327674) | 1 | 8 | 11 | 56 | 12 | ||||
8234 | 121391 | Undocumented 4 | Shrub :: Shrub 66 | 1301x 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993851 | 2106604 | 37.7639796518152 | -122.464467327674 | (37.7639796518152, -122.464467327674) | 1 | 8 | 11 | 56 | 12 | ||||
49423 | 181571 | DPW Maintained 1 | Shrub :: Shrub 66 | 1200 Sunset Blvd | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984860.385 | 2106736.0056 | 37.7638197374851 | -122.495572469111 | (37.7638197374851, -122.495572469111) | 1 | 8 | 3 | 56 | 35 | |||
10543 | 184869 | DPW Maintained 1 | Shrub :: Shrub 66 | 1201 Sunset Blvd | 58 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984640.7069 | 2106821.7773 | 37.7640423761792 | -122.496338586447 | (37.7640423761792, -122.496338586447) | 1 | 8 | 3 | 56 | 35 | |||
120610 | 181577 | DPW Maintained 1 | Shrub :: Shrub 66 | 1200 Sunset Blvd | 59 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984846.2035 | 2106866.5794 | 37.7641774260073 | -122.495631149537 | (37.7641774260073, -122.495631149537) | 1 | 8 | 3 | 56 | 35 | |||
69162 | 181582 | DPW Maintained 1 | Shrub :: Shrub 66 | 1200 Sunset Blvd | 72 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984863.0361 | 2106906.9776 | 37.7642893338004 | -122.495575911156 | (37.7642893338004, -122.495575911156) | 1 | 8 | 3 | 56 | 35 | |||
66991 | 96631 | Permitted Site 7 | Shrub :: Shrub 66 | 1212 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 4x4 | Permit Number 776835 | 5993035.2 | 2107183.3 | 37.7655231963247 | -122.467331039359 | (37.7655231963247, -122.467331039359) | 11 | 8 | 11 | 56 | 12 | ||
143620 | 106469 | Undocumented 4 | Shrub :: Shrub 66 | 100X HENRY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 5x5 | 6002548 | 2107375 | 37.7665941299684 | -122.434442151396 | (37.7665941299684, -122.434442151396) | 15 | 5 | 5 | 28862 | 3 | |||
87985 | 237035 | DPW Maintained 1 | Shrub :: Shrub 66 | 150 Octavia St | 2 | : | Tree | DPW 1 | 04/12/2017 02:27:00 PM | 3 | Width 4ft | 6005709.86547 | 2109855.10938 | 37.7735828886787 | -122.423682154918 | (37.7735828886787, -122.423682154918) | 7 | 9 | 11 | 28852 | 10 | ||
157 | 114186 | Undocumented 4 | Shrub :: Shrub 66 | 2200 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997096 | 2109871 | 37.7731365175856 | -122.453479795748 | (37.7731365175856, -122.453479795748) | 15 | 5 | 2 | 29492 | 16 | ||||
48266 | 114185 | Undocumented 4 | Shrub :: Shrub 66 | 2200 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997096 | 2109871 | 37.7731365175856 | -122.453479795748 | (37.7731365175856, -122.453479795748) | 15 | 5 | 2 | 29492 | 16 | ||||
32529 | 237036 | DPW Maintained 1 | Shrub :: Shrub 66 | 150 Octavia St | 4 | : | Tree | DPW 1 | 04/13/2017 02:42:00 PM | 3 | Width 4ft | 6005705.05318 | 2109878.39065 | 37.7736465417793 | -122.423700457022 | (37.7736465417793, -122.423700457022) | 7 | 9 | 11 | 28852 | 10 | ||
147554 | 239154 | DPW Maintained 1 | Shrub :: Shrub 66 | 150 Octavia St | 6 | : | Tree | DPW 1 | 04/13/2017 02:47:00 PM | 3 | Width 4ft | 6005701.84613 | 2109911.12293 | 37.773736235682 | -122.42371387849 | (37.773736235682, -122.42371387849) | 7 | 9 | 11 | 28852 | 10 | ||
82677 | 244391 | DPW Maintained 1 | Shrub :: Shrub 66 | 250 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2017 01:16:00 PM | 3 | Width 0ft | 6005650.1507 | 2110201.4148 | 37.774530388668 | -122.423913347785 | (37.774530388668, -122.423913347785) | 7 | 9 | 11 | 28852 | 10 | ||
118266 | 244393 | DPW Maintained 1 | Shrub :: Shrub 66 | 250 Octavia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2017 01:35:00 PM | 3 | Width 0ft | 6005645.568 | 2110235.0213 | 37.774622405266 | -122.423931590501 | (37.774622405266, -122.423931590501) | 7 | 9 | 11 | 28852 | 10 | ||
36468 | 140265 | DPW Maintained 1 | Shrub :: Shrub 66 | 2100X Grove St | 3 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 0 | Width 0ft | 5997671.17 | 2110272.3417 | 37.7742714515841 | -122.45151917218 | (37.7742714515841, -122.45151917218) | 15 | 5 | 2 | 29492 | 16 | |||
143999 | 244348 | DPW Maintained 1 | Shrub :: Shrub 66 | 300 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/19/2017 02:44:00 PM | 3 | Width 0ft | 6005622.9962 | 2110384.2841 | 37.7750309704349 | -122.424020287681 | (37.7750309704349, -122.424020287681) | 7 | 9 | 11 | 28852 | 10 | ||
126230 | 244349 | DPW Maintained 1 | Shrub :: Shrub 66 | 300 Octavia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/19/2017 02:48:00 PM | 3 | Width 0ft | 6005619.6911 | 2110403.6421 | 37.7750839362118 | -122.424033097665 | (37.7750839362118, -122.424033097665) | 7 | 9 | 11 | 28852 | 10 | ||
90692 | 244351 | DPW Maintained 1 | Shrub :: Shrub 66 | 300 Octavia St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2017 07:17:00 AM | 3 | Width 0ft | 6005616.3861 | 2110436.6924 | 37.7751744977295 | -122.424046881247 | (37.7751744977295, -122.424046881247) | 7 | 9 | 11 | 28852 | 10 | ||
126561 | 244299 | DPW Maintained 1 | Shrub :: Shrub 66 | 350 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2017 11:32:00 AM | 3 | Width 0ft | 6005603.4021 | 2110525.6921 | 37.7754181362545 | -122.424098126533 | (37.7754181362545, -122.424098126533) | 7 | 9 | 11 | 28852 | 10 | ||
21592 | 244300 | DPW Maintained 1 | Shrub :: Shrub 66 | 350 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2017 11:46:00 AM | 3 | Width 0ft | 6005602.4578 | 2110538.44 | 37.7754530855803 | -122.424102299872 | (37.7754530855803, -122.424102299872) | 7 | 9 | 11 | 28852 | 10 | ||
73743 | 244301 | DPW Maintained 1 | Shrub :: Shrub 66 | 350 Octavia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2017 11:53:00 AM | 3 | Width 0ft | 6005600.097 | 2110553.5487 | 37.7754944371133 | -122.424111541162 | (37.7754944371133, -122.424111541162) | 7 | 9 | 11 | 28852 | 10 | ||
163415 | 139390 | DPW Maintained 1 | Shrub :: Shrub 66 | 432 OCTAVIA ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2017 03:33:00 PM | 3 | Width 0ft | 6005538.2982 | 2110931.9956 | 37.7765300709458 | -122.424352241322 | (37.7765300709458, -122.424352241322) | 7 | 9 | 11 | 28852 | 10 | ||
41363 | 102755 | Undocumented 4 | Shrub :: Shrub 66 | 61 Jordan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 5996159.1 | 2114114.4 | 37.7847340229516 | -122.457027629275 | (37.7847340229516, -122.457027629275) | 11 | 6 | 1 | 54 | 31 | |||
105604 | 23896 | DPW Maintained 1 | Shrub :: Shrub 66 | 1581 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/24/2017 12:00:00 AM | 3 | 3x3 | 6003535.3531022 | 2114132.0136397 | 37.7852032161945 | -122.431509502733 | (37.7852032161945, -122.431509502733) | 13 | 9 | 11 | 29490 | 13 | ||
59943 | 100203 | DPW Maintained 1 | Shrub :: Shrub 66 | 2237 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4x4 | 6001906 | 2114287 | 37.7855362863546 | -122.437157652203 | (37.7855362863546, -122.437157652203) | 13 | 6 | 11 | 29490 | 13 | |||
78365 | 12755 | DPW Maintained 1 | Shrub :: Shrub 66 | 1733 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2008 12:00:00 AM | 3 | 3X3 | 5990033.85435 | 2114674.56985 | 37.7859184370017 | -122.478259694764 | (37.7859184370017, -122.478259694764) | 11 | 6 | 2 | 55 | 26 | ||
149312 | 104783 | Undocumented 4 | Shrub :: Shrub 66 | 50 Walnut St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998501.2 | 2116298 | 37.790863832623 | -122.449082132455 | (37.790863832623, -122.449082132455) | 13 | 6 | 1 | 54 | 31 | ||||
112926 | 251642 | DPW Maintained 1 | Shrub :: Shrub 66 | 2253 Broderick St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 3x3 | 6000298.51737 | 2116393.24113 | 37.7912279703404 | -122.442870356286 | (37.7912279703404, -122.442870356286) | 13 | 6 | 1 | 29490 | 27 | ||||
9498 | 97930 | Undocumented 4 | Shrub :: Shrub 66 | 1615 Grant Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010461.1 | 2120070.1 | 37.801897866839 | -122.40796734514 | (37.801897866839, -122.40796734514) | 3 | 1 | 10 | 308 | 23 |
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) );