trees
18 rows where Zip Codes = 63 and qSpecies_id = 5 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4441 | 246422 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Duncan St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6003829.35465 | 2099854.81871 | 37.7460181445246 | -122.429473817668 | (37.7460181445246, -122.429473817668) | 2 | 7 | 5 | 63 | 22 | |||
31579 | 225050 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 500x 27th St | 24 | Median : Cutout | Tree | DPW 1 | 11 | Width 4ft | 6002949.31338 | 2100070.05084 | 37.7465592558077 | -122.432532251866 | (37.7465592558077, -122.432532251866) | 2 | 7 | 5 | 63 | 22 | |||
36033 | 37053 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 231 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/2015 12:00:00 AM | 3 | 6x9 | Permit Number 775674 | 6005030.06979159 | 2099868.96006137 | 37.7461248828886 | -122.425322907066 | (37.7461248828886, -122.425322907066) | 2 | 7 | 5 | 63 | 22 |
51291 | 225053 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001218.80684 | 2096592.16387 | 37.7369115105593 | -122.438267032523 | (37.7369115105593, -122.438267032523) | 2 | 7 | 5 | 63 | 7 | |||
60894 | 246420 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Duncan St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6003851.19686 | 2099854.61267 | 37.7460188154337 | -122.429398275524 | (37.7460188154337, -122.429398275524) | 2 | 7 | 5 | 63 | 22 | |||
61480 | 246510 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 231 Duncan St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6004993.26159 | 2099869.66747 | 37.7461247456624 | -122.425450235552 | (37.7461247456624, -122.425450235552) | 2 | 7 | 5 | 63 | 22 | |||
62355 | 225056 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 354 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001081.74278 | 2096696.02818 | 37.737188901045 | -122.438748363154 | (37.737188901045, -122.438748363154) | 2 | 7 | 5 | 63 | 7 | |||
67810 | 41699 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2 Mizpah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42149 | 6001021.55719924 | 2096664.38095079 | 37.7370985809646 | -122.438954184383 | (37.7370985809646, -122.438954184383) | 2 | 7 | 5 | 63 | 7 | ||
110285 | 32421 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/1996 12:00:00 AM | 12 | Permit Number 36948 | 6000917.26502 | 2096711.23126 | 37.7372212865363 | -122.439318125938 | (37.7372212865363, -122.439318125938) | 2 | 7 | 5 | 63 | 7 | ||
110454 | 246421 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Duncan St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6003840.65408 | 2099855.19689 | 37.7460198226686 | -122.429434772709 | (37.7460198226686, -122.429434772709) | 2 | 7 | 5 | 63 | 22 | |||
117653 | 205999 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 60 Chilton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001682.52176 | 2095686.82759 | 37.7344520302196 | -122.436598984369 | (37.7344520302196, -122.436598984369) | 2 | 7 | 5 | 63 | 7 | |||
127978 | 225055 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 348 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6001114.83392 | 2096694.1461 | 37.7371856158122 | -122.438633817409 | (37.7371856158122, -122.438633817409) | 2 | 7 | 5 | 63 | 7 | |||
131544 | 59362 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 300 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/1980 12:00:00 AM | Permit Number 18713 | 6001270.92113106 | 2096540.31776103 | 37.7367721171555 | -122.4380831379 | (37.7367721171555, -122.4380831379) | 2 | 7 | 5 | 63 | 7 | |||
168615 | 4389 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 56 Chilton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/2008 12:00:00 AM | 30 | 3x3 | 6001657.8215553 | 2095631.9001159 | 37.7342998083721 | -122.436680450501 | (37.7342998083721, -122.436680450501) | 2 | 7 | 5 | 63 | 7 | ||
170988 | 225052 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 375 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6000953.83658 | 2096674.21341 | 37.7371217252913 | -122.439189029173 | (37.7371217252913, -122.439189029173) | 2 | 7 | 5 | 63 | 7 | |||
172941 | 225057 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 360 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6001062.01743 | 2096696.77883 | 37.7371898399477 | -122.438816616317 | (37.7371898399477, -122.438816616317) | 2 | 7 | 5 | 63 | 7 | |||
175659 | 225049 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 500x 27th St | 22 | Median : Cutout | Tree | DPW 1 | 6 | Width 4ft | 6002919.63953 | 2100068.30287 | 37.7465527734974 | -122.432634735922 | (37.7465527734974, -122.432634735922) | 2 | 7 | 5 | 63 | 22 | |||
191495 | 225054 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 342 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6001139.36381 | 2096693.29596 | 37.7371846769336 | -122.438548945674 | (37.7371846769336, -122.438548945674) | 2 | 7 | 5 | 63 | 7 |
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) );