trees
20 rows where PlotSize = "Width 0ft", Supervisor Districts = 4 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13132 | 207127 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 2 | Front Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 5991327.69264 | 2095651.06492 | 37.7337599569436 | -122.472396083831 | (37.7337599569436, -122.472396083831) | 1 | 8 | 4 | 64 | 40 | |||
13504 | 207123 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 6 | Front Yard : Yard | Tree | DPW 1 | 08/18/2016 09:51:00 AM | 21 | Width 0ft | 5991338.6165 | 2095665.48618 | 37.7338001863266 | -122.472359368113 | (37.7338001863266, -122.472359368113) | 1 | 8 | 4 | 64 | 40 | ||
25781 | 207137 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 103 | : | Tree | Private 2 | 12 | Width 0ft | 5991231.72322 | 2092011.81443 | 37.7237619311543 | -122.47246265254 | (37.7237619311543, -122.47246265254) | 9 | 8 | 4 | 64 | 40 | |||
26539 | 207135 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 99 | : | Tree | Private 2 | 5 | Width 0ft | 5991243.40911 | 2092046.59438 | 37.7238581046423 | -122.472424791093 | (37.7238581046423, -122.472424791093) | 9 | 8 | 4 | 64 | 40 | |||
42527 | 207128 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 1 | Front Yard : Yard | Tree | Private 2 | 15 | Width 0ft | 5991324.62806 | 2095649.61894 | 37.7337558092758 | -122.472406573513 | (37.7337558092758, -122.472406573513) | 1 | 8 | 4 | 64 | 40 | |||
60345 | 207132 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 87 | : | Tree | Private 2 | 16 | Width 0ft | 5991236.29103 | 2092157.26983 | 37.7241615799784 | -122.472457461649 | (37.7241615799784, -122.472457461649) | 9 | 8 | 4 | 64 | 40 | |||
61664 | 207136 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 100 | : | Tree | Private 2 | 6 | Width 0ft | 5991240.31686 | 2092039.54753 | 37.7238385767639 | -122.472434966904 | (37.7238385767639, -122.472434966904) | 9 | 8 | 4 | 64 | 40 | |||
71159 | 207133 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 90 | : | Tree | Private 2 | 10 | Width 0ft | 5991231.48328 | 2092142.91587 | 37.7241218892943 | -122.472473035196 | (37.7241218892943, -122.472473035196) | 9 | 8 | 4 | 64 | 40 | |||
78917 | 207118 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 12 | Front Yard : Yard | Tree | Private 2 | 27 | Width 0ft | 5991361.11034 | 2095702.06647 | 37.7339019284143 | -122.472284266614 | (37.7339019284143, -122.472284266614) | 1 | 8 | 4 | 64 | 40 | |||
83580 | 207121 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 8 | Front Yard : Yard | Tree | Private 2 | 20 | Width 0ft | 5991346.9817 | 2095677.27593 | 37.7338330421511 | -122.472331306559 | (37.7338330421511, -122.472331306559) | 1 | 8 | 4 | 64 | 40 | |||
85806 | 207130 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Junipero Serra Blvd | 22 | : | Tree | Private 2 | 24 | Width 0ft | 5991387.56325 | 2094477.49413 | 37.7305410918021 | -122.472103582925 | (37.7305410918021, -122.472103582925) | 9 | 8 | 4 | 64 | 40 | |||
91870 | 207134 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 98 | : | Tree | Private 2 | 12 | Width 0ft | 5991244.20773 | 2092057.90852 | 37.7238892166875 | -122.472422854852 | (37.7238892166875, -122.472422854852) | 9 | 8 | 4 | 64 | 40 | |||
126406 | 207120 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 9 | Front Yard : Yard | Tree | Private 2 | 21 | Width 0ft | 5991349.86178 | 2095682.72956 | 37.7338481831293 | -122.472321746778 | (37.7338481831293, -122.472321746778) | 1 | 8 | 4 | 64 | 40 | |||
131012 | 207124 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 5 | Front Yard : Yard | Tree | DPW 1 | 08/18/2016 09:54:00 AM | 9 | Width 0ft | 5991335.55729 | 2095661.67857 | 37.7337895545331 | -122.472369667134 | (37.7337895545331, -122.472369667134) | 1 | 8 | 4 | 64 | 40 | ||
134954 | 207131 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 500 Junipero Serra Blvd | 23 | : | Tree | Private 2 | 14 | Width 0ft | 5991341.74557 | 2093676.61882 | 37.7283394372056 | -122.472203623519 | (37.7283394372056, -122.472203623519) | 9 | 8 | 4 | 64 | 40 | |||
137267 | 207138 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 123 | : | Tree | Private 2 | 8 | Width 0ft | 5991217.22752 | 2091775.34767 | 37.7231118130309 | -122.472495529957 | (37.7231118130309, -122.472495529957) | 9 | 8 | 4 | 64 | 40 | |||
157961 | 207119 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 10 | Front Yard : Yard | Tree | Private 2 | 25 | Width 0ft | 5991353.65823 | 2095688.25461 | 37.7338635732432 | -122.472309024061 | (37.7338635732432, -122.472309024061) | 1 | 8 | 4 | 64 | 40 | |||
162214 | 207122 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 7 | Front Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 5991343.33969 | 2095670.4637 | 37.7338141267018 | -122.472343401524 | (37.7338141267018, -122.472343401524) | 1 | 8 | 4 | 64 | 40 | |||
172236 | 207126 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 3 | Front Yard : Yard | Tree | DPW 1 | 08/18/2016 09:59:00 AM | 13 | Width 0ft | 5991329.52565 | 2095655.77453 | 37.7337729944342 | -122.472390089849 | (37.7337729944342, -122.472390089849) | 1 | 8 | 4 | 64 | 40 | ||
183941 | 207125 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 4 | Front Yard : Yard | Tree | DPW 1 | 08/18/2016 09:56:00 AM | 13 | Width 0ft | 5991332.89244 | 2095658.50101 | 37.7337806755214 | -122.47237864866 | (37.7337806755214, -122.47237864866) | 1 | 8 | 4 | 64 | 40 |
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) );