trees
26 rows where Fire Prevention Districts = 1, qLegalStatus_id = 7 and qSpecies_id = 47
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13174 | 68069 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 239 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1993 12:00:00 AM | Permit Number 31806 | 5993313.66059206 | 2103207.09024288 | 37.7546216328473 | -122.466078949095 | (37.7546216328473, -122.466078949095) | 1 | 8 | 4 | 56 | 12 | ||
| 26749 | 31667 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2571 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1995 12:00:00 AM | Permit Number 35175 | 5981777.56166178 | 2097600.02639588 | 37.7385539042174 | -122.505557573977 | (37.7385539042174, -122.505557573977) | 1 | 8 | 3 | 29491 | 35 | ||
| 28788 | 50114 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1252 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2003 12:00:00 AM | Permit Number 46839 | 5992244.12505327 | 2098460.15223335 | 37.7415260004029 | -122.469432140867 | (37.7415260004029, -122.469432140867) | 1 | 8 | 4 | 29491 | 40 | ||
| 34167 | 69291 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 830 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/1994 12:00:00 AM | Permit Number 33363 | 5991479.92264349 | 2102518.55863113 | 37.7526251419757 | -122.472370253301 | (37.7526251419757, -122.472370253301) | 1 | 8 | 4 | 56 | 12 | ||
| 40068 | 31575 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1922 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | Permit Number 35114 | 5989431.17806618 | 2102257.22974077 | 37.7517888142139 | -122.479435972521 | (37.7517888142139, -122.479435972521) | 1 | 8 | 3 | 29491 | 35 | ||
| 56247 | 35417 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 221 Crestmont Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38870 | 5995170.62655697 | 2103759.11614599 | 37.7562443131302 | -122.459697089533 | (37.7562443131302, -122.459697089533) | 1 | 5 | 4 | 63 | 12 | |||
| 68109 | 50881 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2040 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47391 | 5991642.80129947 | 2101534.85210656 | 37.7499335653235 | -122.471735313093 | (37.7499335653235, -122.471735313093) | 1 | 8 | 4 | 29491 | 12 | ||
| 77823 | 31942 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1300 La Playa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39715 | 5980916.9213303 | 2106151.77480086 | 37.761983899941 | -122.50916807627 | (37.761983899941, -122.50916807627) | 1 | 8 | 3 | 56 | 35 | ||
| 80463 | 79056 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1862 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50038 | 5983215.17096299 | 2102463.12302331 | 37.7519911277095 | -122.500946646871 | (37.7519911277095, -122.500946646871) | 1 | 8 | 3 | 56 | 35 | ||
| 84877 | 31600 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1631 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | Permit Number 35126 | 5988991.64827869 | 2102380.23074862 | 37.7521010026968 | -122.480964913447 | (37.7521010026968, -122.480964913447) | 1 | 8 | 3 | 29491 | 35 | ||
| 90861 | 31375 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 630 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1995 12:00:00 AM | Permit Number 34977 | 5991276.37232485 | 2099107.33925567 | 37.7432470351435 | -122.472825445815 | (37.7432470351435, -122.472825445815) | 1 | 8 | 4 | 29491 | 40 | ||
| 99619 | 67131 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1439 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1992 12:00:00 AM | Permit Number 30551 | 5994253.6761319 | 2105720.38065143 | 37.7615766669983 | -122.463010486718 | (37.7615766669983, -122.463010486718) | 1 | 5 | 11 | 56 | 12 | ||
| 105324 | 32605 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1370 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37071 | 5984960.54583105 | 2105873.44387063 | 37.7614572492102 | -122.49516243722 | (37.7614572492102, -122.49516243722) | 1 | 8 | 3 | 56 | 35 | ||
| 119732 | 47881 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1454 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50547 | 5982810.24276317 | 2105223.95269531 | 37.759547805419 | -122.502551248021 | (37.759547805419, -122.502551248021) | 1 | 8 | 3 | 56 | 35 | ||
| 128606 | 82810 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2730 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50728 | 5983104.2980141 | 2096628.76061893 | 37.7359650625832 | -122.500898621502 | (37.7359650625832, -122.500898621502) | 1 | 8 | 3 | 29491 | 35 | ||
| 136204 | 35418 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 221 Crestmont Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38870 | 5995170.62655697 | 2103759.11614599 | 37.7562443131302 | -122.459697089533 | (37.7562443131302, -122.459697089533) | 1 | 5 | 4 | 63 | 12 | |||
| 137363 | 84886 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3138 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | Permit No. 49329 | 5983290 | 2099514 | 37.7438980447125 | -122.500469849117 | (37.7438980447125, -122.500469849117) | 1 | 8 | 3 | 29491 | 35 | |||
| 138561 | 36089 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1706 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/2002 12:00:00 AM | Permit Number 44997 | 5981032.08177403 | 2103436.82774177 | 37.7545362217712 | -122.508568229446 | (37.7545362217712, -122.508568229446) | 1 | 8 | 3 | 56 | 35 | ||
| 154772 | 85386 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1239 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49657 | 5981144.8 | 2106623.2 | 37.7632917298848 | -122.508414943002 | (37.7632917298848, -122.508414943002) | 1 | 8 | 3 | 56 | 35 | ||||
| 157838 | 46382 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2495 43rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2002 12:00:00 AM | Permit Number 44618 | 5983000.42559938 | 2098163.19803029 | 37.7401721103617 | -122.501371213543 | (37.7401721103617, -122.501371213543) | 1 | 8 | 3 | 29491 | 35 | ||
| 165329 | 46381 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2495 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2002 12:00:00 AM | Permit Number 44618 | 5983000.42559938 | 2098163.19803029 | 37.7401721103617 | -122.501371213543 | (37.7401721103617, -122.501371213543) | 1 | 8 | 3 | 29491 | 35 | ||
| 166199 | 79279 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2706 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50726 | 5983101.82229012 | 2096724.27729962 | 37.7362271801162 | -122.50091424264 | (37.7362271801162, -122.50091424264) | 1 | 8 | 3 | 29491 | 35 | ||
| 171915 | 82814 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2724 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50727 | 5983103.67908303 | 2096652.63979189 | 37.7360305919754 | -122.500902526777 | (37.7360305919754, -122.500902526777) | 1 | 8 | 3 | 29491 | 35 | ||
| 178843 | 58925 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3925 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1994 12:00:00 AM | Permit Number 18201 | 5982715.08927534 | 2104886.86517056 | 37.7586166666309 | -122.502855377053 | (37.7586166666309, -122.502855377053) | 1 | 8 | 3 | 56 | 35 | ||
| 185884 | 35419 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 221 Crestmont Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38870 | 5995170.62655697 | 2103759.11614599 | 37.7562443131302 | -122.459697089533 | (37.7562443131302, -122.459697089533) | 1 | 5 | 4 | 63 | 12 | |||
| 193603 | 68315 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3820 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32128 | 5981623.22584135 | 2100818.01716678 | 37.7473805290726 | -122.506329747472 | (37.7473805290726, -122.506329747472) | 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) );