trees
127 rows where Zip Codes = 63 and qSpecies_id = 95 sorted by qCareAssistant
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 181561 | 1357 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 315 Amber Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000103.7431583 | 2099357.1209482 | 37.7444399432052 | -122.44232072604 | (37.7444399432052, -122.44232072604) | 2 | 7 | 5 | 63 | 22 | |||
| 190018 | 233951 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 162 Everson St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6002803.21932 | 2097405.15608 | 37.7392337885099 | -122.432847082927 | (37.7392337885099, -122.432847082927) | 2 | 7 | 5 | 63 | 7 | |||
| 192040 | 233954 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 51 Digby St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6002902.189 | 2097480.2364 | 37.7394455545679 | -122.432510251748 | (37.7394455545679, -122.432510251748) | 2 | 7 | 5 | 63 | 7 | |||
| 21107 | 58677 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 142 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20288 | 6004283.38599027 | 2097405.52604754 | 37.7393186445117 | -122.427729355445 | (37.7393186445117, -122.427729355445) | 2 | 7 | 5 | 63 | 7 | ||
| 23097 | 60652 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 125 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20284 | 6004314.87851567 | 2097476.26675857 | 37.7395146637963 | -122.427625506935 | (37.7395146637963, -122.427625506935) | 2 | 7 | 5 | 63 | 7 | ||
| 24315 | 65352 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 252 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1989 12:00:00 AM | Permit Number 28187 | 6001484.29754015 | 2096470.76224415 | 37.736593266506 | -122.437340424735 | (37.736593266506, -122.437340424735) | 2 | 7 | 5 | 63 | 7 | ||
| 28451 | 64133 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 610 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24904 | 6002610.61709759 | 2098908.05619778 | 37.7433494776015 | -122.433620394679 | (37.7433494776015, -122.433620394679) | 2 | 7 | 5 | 63 | 22 | ||
| 39199 | 65341 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 188 Lippard Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1989 12:00:00 AM | Permit Number 28173 | 6001746.6239921 | 2095001.97603702 | 37.732575228117 | -122.436328365067 | (37.732575228117, -122.436328365067) | 9 | 7 | 5 | 63 | 40 | ||
| 41525 | 64413 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 125 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/1988 12:00:00 AM | Permit Number 25260 | 6003685.70575404 | 2097659.19041399 | 37.7399813214783 | -122.429813955945 | (37.7399813214783, -122.429813955945) | 2 | 7 | 5 | 63 | 7 | ||
| 49102 | 65342 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 186 Lippard Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1989 12:00:00 AM | Permit Number 28174 | 6001746.84094237 | 2095012.67377274 | 37.7326046139677 | -122.436328380361 | (37.7326046139677, -122.436328380361) | 9 | 7 | 5 | 63 | 40 | ||
| 61985 | 60427 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 426 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1996 12:00:00 AM | Permit Number 20011 | 6003800.98811791 | 2098974.33117024 | 37.7435989232844 | -122.429509123627 | (37.7435989232844, -122.429509123627) | 2 | 7 | 5 | 63 | 22 | ||
| 73999 | 60651 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 119 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20282 | 6004308.90872875 | 2097494.4365772 | 37.7395642163021 | -122.42764744207 | (37.7395642163021, -122.42764744207) | 2 | 7 | 5 | 63 | 7 | ||
| 95043 | 60653 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 135 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20285 | 6004324.82816302 | 2097445.98371997 | 37.7394320762559 | -122.427588948431 | (37.7394320762559, -122.427588948431) | 2 | 7 | 5 | 63 | 7 | ||
| 99260 | 65369 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 109 Roanoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1989 12:00:00 AM | Permit Number 28207 | 6003410.83232501 | 2096243.47479324 | 37.7360785209393 | -122.430663356711 | (37.7360785209393, -122.430663356711) | 2 | 7 | 5 | 63 | 7 | ||
| 106788 | 64121 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 375 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24892 | 6003475.30119676 | 2099489.67816755 | 37.7449955011148 | -122.430672035562 | (37.7449955011148, -122.430672035562) | 2 | 7 | 5 | 63 | 22 | ||
| 114509 | 65331 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 141 Brompton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1989 12:00:00 AM | Permit Number 28154 | 6002111.55813884 | 2095203.52869324 | 37.7331493741938 | -122.435081111485 | (37.7331493741938, -122.435081111485) | 9 | 7 | 5 | 63 | 40 | ||
| 116419 | 44362 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 122 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/2001 12:00:00 AM | Permit Number 43732 | 6004263.48669743 | 2097466.09211909 | 37.7394838194805 | -122.427802472727 | (37.7394838194805, -122.427802472727) | 2 | 7 | 5 | 63 | 7 | ||
| 144285 | 60437 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 478 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1982 12:00:00 AM | Permit Number 20021 | 6003480.72669139 | 2098956.48563767 | 37.743531785344 | -122.430615235496 | (37.743531785344, -122.430615235496) | 2 | 7 | 5 | 63 | 22 | ||
| 151706 | 60433 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 451 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1982 12:00:00 AM | Permit Number 20017 | 6003656.06819054 | 2098914.17531059 | 37.7434255428329 | -122.430005930771 | (37.7434255428329, -122.430005930771) | 2 | 7 | 5 | 63 | 22 | ||
| 160118 | 63660 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 423 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1987 12:00:00 AM | Permit Number 24308 | 6003762.6367623 | 2100089.82328361 | 37.7466596348506 | -122.429721277679 | (37.7466596348506, -122.429721277679) | 2 | 7 | 5 | 63 | 22 | ||
| 165245 | 60510 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 422 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1982 12:00:00 AM | Permit Number 20111 | 6003825.62361314 | 2098975.70390357 | 37.7436040873115 | -122.429424038012 | (37.7436040873115, -122.429424038012) | 2 | 7 | 5 | 63 | 22 | ||
| 166307 | 60430 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 444 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1982 12:00:00 AM | Permit Number 20014 | 6003690.1283836 | 2098968.15386996 | 37.743575684401 | -122.429892008764 | (37.743575684401, -122.429892008764) | 2 | 7 | 5 | 63 | 22 | ||
| 166556 | 60669 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 274 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20303 | 6004309.8735522 | 2096796.94934371 | 37.7376491294631 | -122.427594426597 | (37.7376491294631, -122.427594426597) | 2 | 7 | 5 | 63 | 7 | ||
| 180278 | 65361 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 7 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1989 12:00:00 AM | Permit Number 28196 | 6002832.7941803 | 2095807.19286717 | 37.7348478258508 | -122.432630712358 | (37.7348478258508, -122.432630712358) | 2 | 7 | 5 | 63 | 7 | ||
| 184927 | 60429 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 435 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1991 12:00:00 AM | Permit Number 29958 | 6003754.61017147 | 2098919.66624389 | 37.743446200008 | -122.429665589175 | (37.743446200008, -122.429665589175) | 2 | 7 | 5 | 63 | 22 | ||
| 186096 | 65343 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 184 Lippard Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1989 12:00:00 AM | Permit Number 28175 | 6001750.39660253 | 2095029.30684218 | 37.7326504865842 | -122.436317277562 | (37.7326504865842, -122.436317277562) | 9 | 7 | 5 | 63 | 40 | ||
| 189339 | 64316 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 68 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25133 | 6004266.78630985 | 2097807.98626151 | 37.740422769496 | -122.427815418773 | (37.740422769496, -122.427815418773) | 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) );