trees
52 rows where PlotSize = "Width 0ft" and qSpecies_id = 66 sorted by qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
153 | 185313 | DPW Maintained 1 | Shrub :: Shrub 66 | 2601 Sunset Blvd | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984983.1747 | 2097234.3473 | 37.7377379790483 | -122.494447317023 | (37.7377379790483, -122.494447317023) | 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 | |||
13397 | 185258 | DPW Maintained 1 | Shrub :: Shrub 66 | 2101 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5986433.4347 | 2097526.3066 | 37.7386243913853 | -122.489454599165 | (37.7386243913853, -122.489454599165) | 1 | 8 | 3 | 29491 | 35 | |||
17255 | 185555 | DPW Maintained 1 | Shrub :: Shrub 66 | 2201 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984902.7901 | 2099826.3861 | 37.7448503133319 | -122.494916305221 | (37.7448503133319, -122.494916305221) | 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 | |||
34922 | 185312 | DPW Maintained 1 | Shrub :: Shrub 66 | 2601 Sunset Blvd | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984965.1696 | 2097238.5346 | 37.7377484224906 | -122.494509877006 | (37.7377484224906, -122.494509877006) | 1 | 8 | 3 | 29491 | 35 | |||
36371 | 186363 | DPW Maintained 1 | Shrub :: Shrub 66 | 1801 Sunset Blvd | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 0ft | 5984829.0026 | 2102575.9576 | 37.7523955649491 | -122.495374186734 | (37.7523955649491, -122.495374186734) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
43758 | 182677 | DPW Maintained 1 | Shrub :: Shrub 66 | 1715 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5988712.8958 | 2103624.6472 | 37.7555016296557 | -122.482020022938 | (37.7555016296557, -122.482020022938) | 1 | 8 | 3 | 56 | 35 | |||
49069 | 184753 | DPW Maintained 1 | Shrub :: Shrub 66 | 1301 Sunset Blvd | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984707.1578 | 2106087.4001 | 37.7620298750768 | -122.496054573405 | (37.7620298750768, -122.496054573405) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
53305 | 187234 | DPW Maintained 1 | Shrub :: Shrub 66 | 2401 Sunset Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984956.0101 | 2098625.8109 | 37.7415569740276 | -122.494643790117 | (37.7415569740276, -122.494643790117) | 1 | 8 | 3 | 29491 | 35 | |||
54182 | 184754 | DPW Maintained 1 | Shrub :: Shrub 66 | 1301 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984657.4145 | 2106082.8434 | 37.7620144499807 | -122.496226277389 | (37.7620144499807, -122.496226277389) | 1 | 8 | 3 | 56 | 35 | |||
61810 | 184751 | DPW Maintained 1 | Shrub :: Shrub 66 | 1301 Sunset Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984675.641 | 2106097.6525 | 37.7620561792493 | -122.4961643326 | (37.7620561792493, -122.4961643326) | 1 | 8 | 3 | 56 | 35 | |||
65283 | 186427 | DPW Maintained 1 | Shrub :: Shrub 66 | 1601 Sunset Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984725.0315 | 2104075.456 | 37.7565066846119 | -122.495844334494 | (37.7565066846119, -122.495844334494) | 1 | 8 | 3 | 56 | 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 | |||
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 | |||
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 | |||
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 | |||
77702 | 187253 | DPW Maintained 1 | Shrub :: Shrub 66 | 2401 Sunset Blvd | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984962.1374 | 2098459.5582 | 37.7411008475889 | -122.494610350765 | (37.7411008475889, -122.494610350765) | 1 | 8 | 3 | 29491 | 35 | |||
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 | ||
98817 | 181343 | DPW Maintained 1 | Shrub :: Shrub 66 | 2500 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985164.5677 | 2097705.9234 | 37.7390434150027 | -122.493854905389 | (37.7390434150027, -122.493854905389) | 1 | 8 | 3 | 29491 | 35 | |||
102820 | 186362 | DPW Maintained 1 | Shrub :: Shrub 66 | 1801 Sunset Blvd | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5984819.5753 | 2102574.8802 | 37.7523920547151 | -122.495406707945 | (37.7523920547151, -122.495406707945) | 1 | 8 | 3 | 56 | 35 | |||
107863 | 182676 | DPW Maintained 1 | Shrub :: Shrub 66 | 1715 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5988712.3482 | 2103638.8826 | 37.7555406843938 | -122.482022959471 | (37.7555406843938, -122.482022959471) | 1 | 8 | 3 | 56 | 35 | |||
110736 | 187251 | DPW Maintained 1 | Shrub :: Shrub 66 | 2401 Sunset Blvd | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984973.9834 | 2098481.6163 | 37.7411621065182 | -122.494571017919 | (37.7411621065182, -122.494571017919) | 1 | 8 | 3 | 29491 | 35 | |||
112833 | 184750 | DPW Maintained 1 | Shrub :: Shrub 66 | 1301 Sunset Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984665.0089 | 2106100.6902 | 37.7620638971415 | -122.496201328503 | (37.7620638971415, -122.496201328503) | 1 | 8 | 3 | 56 | 35 | |||
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 | ||
120528 | 184752 | DPW Maintained 1 | Shrub :: Shrub 66 | 1301 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984700.7025 | 2106093.8553 | 37.7620472211463 | -122.496077375707 | (37.7620472211463, -122.496077375707) | 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 | |||
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 | |||
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 | |||
133233 | 184755 | DPW Maintained 1 | Shrub :: Shrub 66 | 1301 Sunset Blvd | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984688.1718 | 2106071.0721 | 37.7619839309054 | -122.496119032944 | (37.7619839309054, -122.496119032944) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
140028 | 184206 | DPW Maintained 1 | Shrub :: Shrub 66 | 1484 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5983432.9268 | 2105012.9881 | 37.7590051267749 | -122.500382134012 | (37.7590051267749, -122.500382134012) | 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 | |||
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 | |||
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 | |||
150872 | 184164 | DPW Maintained 1 | Shrub :: Shrub 66 | 1595 44th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5982483.9557 | 2104274.5677 | 37.7569218843537 | -122.503609385397 | (37.7569218843537, -122.503609385397) | 1 | 8 | 3 | 56 | 35 | |||
155034 | 185692 | DPW Maintained 1 | Shrub :: Shrub 66 | 2101 Sunset Blvd | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984851.9348 | 2100530.8696 | 37.7467816562023 | -122.495144090409 | (37.7467816562023, -122.495144090409) | 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 | |||
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 | ||
163645 | 184622 | DPW Maintained 1 | Shrub :: Shrub 66 | 1778 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5983811.7777 | 2103069.4322 | 37.7536908962098 | -122.498928317229 | (37.7536908962098, -122.498928317229) | 1 | 8 | 3 | 56 | 35 | |||
172977 | 185311 | DPW Maintained 1 | Shrub :: Shrub 66 | 2601 Sunset Blvd | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984965.5883 | 2097247.7465 | 37.737773740404 | -122.494509108268 | (37.737773740404, -122.494509108268) | 1 | 8 | 3 | 29491 | 35 | |||
178506 | 184756 | DPW Maintained 1 | Shrub :: Shrub 66 | 1301 Sunset Blvd | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984687.2225 | 2106057.4022 | 37.761946341588 | -122.496121307582 | (37.761946341588, -122.496121307582) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
193173 | 186364 | DPW Maintained 1 | Shrub :: Shrub 66 | 1801 Sunset Blvd | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984815.8043 | 2102571.1093 | 37.7523814800587 | -122.495419470402 | (37.7523814800587, -122.495419470402) | 1 | 8 | 3 | 56 | 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) );