trees
133 rows where qSpecies_id = 66 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
76533 | 27143 | DPW Maintained 1 | Shrub :: Shrub 66 | 1775 Silver Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X3 | 6011388.84182 | 2095356.57174 | 37.7340920254878 | -122.403017629645 | (37.7340920254878, -122.403017629645) | 10 | 3 | 8 | 58 | 1 | |||
88436 | 114528 | Undocumented 4 | Shrub :: Shrub 66 | 1 TIOGA AVE | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6011351 | 2088602 | 37.7155432513192 | -122.402673611341 | (37.7155432513192, -122.402673611341) | 9 | 7 | 8 | 309 | 39 | |||||
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 | ||||
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 | ||
68765 | 185897 | DPW Maintained 1 | Shrub :: Shrub 66 | 2000 Sunset Blvd | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985016.2502 | 2101239.5934 | 37.7487372369942 | -122.494628152274 | (37.7487372369942, -122.494628152274) | 1 | 8 | 3 | 29491 | 35 | |||
66325 | 187025 | DPW Maintained 1 | Shrub :: Shrub 66 | 2501 Sunset Blvd | 44 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984975.6777 | 2097882.1396 | 37.7395162040617 | -122.494520977899 | (37.7395162040617, -122.494520977899) | 1 | 8 | 3 | 29491 | 35 | |||
51790 | 37371 | Permitted Site 7 | Shrub :: Shrub 66 | 755 Morse St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 2 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) | 9 | 7 | 6 | 28861 | 5 |
68664 | 94197 | Permitted Site 7 | Shrub :: Shrub 66 | 355 Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2010 12:00:00 AM | 3x3 | Permit Number 53723 | 5999419.6 | 2091436.9 | 37.7226538624451 | -122.444117342662 | (37.7226538624451, -122.444117342662) | 9 | 7 | 6 | 28861 | 25 | ||
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 | ||
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 | ||||
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 | ||
184604 | 30143 | DPW Maintained 1 | Shrub :: Shrub 66 | 410X Mansell St | 5 | Median : Cutout | Tree | DPW 1 | 0 | POT | 6010678.994322 | 2090457.626596 | 37.7206008798567 | -122.405126964413 | (37.7206008798567, -122.405126964413) | 10 | 3 | 7 | 309 | 28 | |||
67903 | 181355 | DPW Maintained 1 | Shrub :: Shrub 66 | 2300 Sunset Blvd | 53 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985079.1419 | 2099429.3232 | 37.7437704079628 | -122.494277260962 | (37.7437704079628, -122.494277260962) | 1 | 8 | 3 | 29491 | 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 | |||
144357 | 187122 | DPW Maintained 1 | Shrub :: Shrub 66 | 2600 Sunset Blvd | 58 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985165.8082 | 2097341.5801 | 37.7380430985113 | -122.493823774181 | (37.7380430985113, -122.493823774181) | 1 | 8 | 3 | 29491 | 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 | |||
38858 | 98972 | DPW Maintained 1 | Shrub :: Shrub 66 | 825 Shotwell St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 0 | 5x5 | 6008234.2 | 2102998.9 | 37.7548994960031 | -122.414464835105 | (37.7548994960031, -122.414464835105) | 2 | 4 | 7 | 28859 | 19 | ||
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 | ||
96160 | 94198 | Permitted Site 7 | Shrub :: Shrub 66 | 355 Ocean Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2010 12:00:00 AM | 3x3 | Permit Number 53723 | 5999419.6 | 2091436.9 | 37.7226538624451 | -122.444117342662 | (37.7226538624451, -122.444117342662) | 9 | 7 | 6 | 28861 | 25 | ||
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 | ||
183891 | 186250 | DPW Maintained 1 | Shrub :: Shrub 66 | 1701 Sunset Blvd | 61 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984767.3503 | 2103112.4152 | 37.753864919503 | -122.495626952484 | (37.753864919503, -122.495626952484) | 1 | 8 | 3 | 56 | 35 | |||
144873 | 181567 | DPW Maintained 1 | Shrub :: Shrub 66 | 1300 Sunset Blvd | 62 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984855.7554 | 2106265.0899 | 37.7625264639896 | -122.495553745896 | (37.7625264639896, -122.495553745896) | 1 | 8 | 3 | 56 | 35 | |||
126370 | 187377 | DPW Maintained 1 | Shrub :: Shrub 66 | 2200 Sunset Blvd | 63 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985052.2703 | 2100029.8298 | 37.7454176637381 | -122.49441443213 | (37.7454176637381, -122.49441443213) | 1 | 8 | 3 | 29491 | 35 | |||
127768 | 30054 | DPW Maintained 1 | Shrub :: Shrub 66 | 610X Junipero Serra Blvd | 7 | Median : Cutout | Tree | DPW 1 | 5991361.953164 | 2093442.610307 | 37.7276980777014 | -122.472116715696 | (37.7276980777014, -122.472116715696) | 9 | 8 | 4 | 64 | 40 | |||||
129104 | 30145 | DPW Maintained 1 | Shrub :: Shrub 66 | 410X Mansell St | 7 | Median : Cutout | Tree | DPW 1 | 0 | POT | 6010678.994322 | 2090457.626596 | 37.7206008798567 | -122.405126964413 | (37.7206008798567, -122.405126964413) | 10 | 3 | 7 | 309 | 28 | |||
133282 | 186340 | DPW Maintained 1 | Shrub :: Shrub 66 | 1801 Sunset Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984827.0787 | 2102831.0491 | 37.7530958632805 | -122.495399651332 | (37.7530958632805, -122.495399651332) | 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 | |||
147623 | 187053 | DPW Maintained 1 | Shrub :: Shrub 66 | 2501 Sunset Blvd | 72 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984954.1557 | 2097623.876 | 37.7388058219757 | -122.494576356208 | (37.7388058219757, -122.494576356208) | 1 | 8 | 3 | 29491 | 35 | |||
27654 | 187054 | DPW Maintained 1 | Shrub :: Shrub 66 | 2501 Sunset Blvd | 73 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984950.4566 | 2097599.3275 | 37.7387382018833 | -122.494587336532 | (37.7387382018833, -122.494587336532) | 1 | 8 | 3 | 29491 | 35 | |||
158923 | 187055 | DPW Maintained 1 | Shrub :: Shrub 66 | 2501 Sunset Blvd | 74 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984955.8371 | 2097567.7171 | 37.7386517231253 | -122.49456640389 | (37.7386517231253, -122.49456640389) | 1 | 8 | 3 | 29491 | 35 | |||
131527 | 187056 | DPW Maintained 1 | Shrub :: Shrub 66 | 2501 Sunset Blvd | 75 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984980.0493 | 2097557.2924 | 37.7386245167659 | -122.49448192258 | (37.7386245167659, -122.49448192258) | 1 | 8 | 3 | 29491 | 35 |
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) );