trees
30 rows where Fire Prevention Districts = 10, SiteOrder = 1 and qSpecies_id = 65 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3939 | 53160 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1747@ 3RD ST Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | 8 | Permit Number 49080 | 6014477.38224 | 2095160.1105 | 37.7337245704136 | -122.392325759332 | (37.7337245704136, -122.392325759332) | 10 | 3 | 8 | 58 | 1 | |
15220 | 63283 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 42 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | 11 | Permit Number 23848 | 6013931.58226 | 2095527.61 | 37.7347033259801 | -122.394238486043 | (37.7347033259801, -122.394238486043) | 10 | 3 | 8 | 58 | 1 | |
21642 | 38204 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 691 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | 14 | Permit Number 40328 | 6010720.89935 | 2091470.20831 | 37.7233835629968 | -122.405053372309 | (37.7233835629968, -122.405053372309) | 10 | 3 | 7 | 309 | 28 | |
26137 | 108762 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 500X Lathrop Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
43315 | 38214 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 331 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | 11 | Permit Number 40337 | 6010588.27199 | 2092325.30166 | 37.7257240567036 | -122.405572039215 | (37.7257240567036, -122.405572039215) | 10 | 3 | 7 | 309 | 28 | |
53408 | 37793 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 347 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | 15 | Permit Number 40121 | 6009401.77176 | 2092702.5768 | 37.7266935573585 | -122.409700314138 | (37.7266935573585, -122.409700314138) | 10 | 3 | 7 | 309 | 28 | |
59999 | 38206 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 756 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | 11 | Permit Number 40330 | 6010781.48445 | 2091161.67808 | 37.7225397893635 | -122.404822228563 | (37.7225397893635, -122.404822228563) | 10 | 3 | 7 | 309 | 28 | |
60145 | 38581 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1483 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 15 | Permit Number 40541 | 6015866.8585 | 2094128.4257 | 37.7309688285238 | -122.387449938884 | (37.7309688285238, -122.387449938884) | 10 | 3 | 8 | 58 | 1 | |
65829 | 68256 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 243 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 16 | Permit Number 32061 | 6009551.9423 | 2093241.4503 | 37.7281816043806 | -122.409219186739 | (37.7281816043806, -122.409219186739) | 10 | 3 | 7 | 309 | 28 | |
74836 | 66622 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 867 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/15/1991 12:00:00 AM | Permit Number 29826 | 6010209.78585513 | 2104179.32451342 | 37.7582514640983 | -122.407715901057 | (37.7582514640983, -122.407715901057) | 10 | 4 | 7 | 28859 | 19 | ||
165874 | 38552 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1820 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 16 | Permit Number 40520 | 6015364.9925 | 2093693.5794 | 37.7297470188732 | -122.389154637038 | (37.7297470188732, -122.389154637038) | 10 | 3 | 8 | 58 | 1 | |
188936 | 113546 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2017 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2015 12:00:00 AM | 1 | Permit Number 775016 | 6011705.09048 | 2105100.13383 | 37.7608633956443 | -122.402609207467 | (37.7608633956443, -122.402609207467) | 10 | 3 | 8 | 28856 | 29 | ||
190011 | 66065 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 615 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1990 12:00:00 AM | 15 | Permit Number 29105 | 6013588.8129 | 2104207.15934 | 37.7585164708659 | -122.396031617282 | (37.7585164708659, -122.396031617282) | 10 | 3 | 8 | 28856 | 29 | |
8836 | 262545 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 1919 Donner Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/2020 12:00:00 AM | 3 | 3x3 | 6011672 | 2093386 | 37.7286970547273 | -122.401900181645 | (37.7286970547273, -122.401900181645) | 10 | 3 | 8 | 58 | 1 | ||
60136 | 108565 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 521 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772537 | 6010495.60195 | 2092202.94019 | 37.7253828953025 | -122.405883778414 | (37.7253828953025, -122.405883778414) | 10 | 3 | 7 | 309 | 28 |
88150 | 82830 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1475 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 9 | 3x3 | Permit Number 52467 | 6015906.1825 | 2094100.414 | 37.7308940918936 | -122.387312034756 | (37.7308940918936, -122.387312034756) | 10 | 3 | 8 | 58 | 1 | |
160888 | 97263 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 220 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773740 | 6009330.61336 | 2094994.97082 | 37.7329839958128 | -122.410108077526 | (37.7329839958128, -122.410108077526) | 10 | 3 | 7 | 309 | 28 | |
186443 | 83009 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 622 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 10 | 3x3 | Permit Number 52378 | 6012068.99141 | 2105489.95153 | 37.7619540583423 | -122.401378022995 | (37.7619540583423, -122.401378022995) | 10 | 3 | 8 | 28856 | 29 | |
4665 | 255219 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 668 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 6010649.61655 | 2091566.6998 | 37.7236445235288 | -122.405306576793 | (37.7236445235288, -122.405306576793) | 10 | 3 | 7 | 309 | 28 | ||
158774 | 83067 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 624 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 10 | 3x6 | Permit Number 52379 | 6012068.69574 | 2105475.40084 | 37.7619140888872 | -122.401378022999 | (37.7619140888872, -122.401378022999) | 10 | 3 | 8 | 28856 | 29 | |
6832 | 221870 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 530 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008584.18129 | 2096552.27767 | 37.7372181568784 | -122.412798757353 | (37.7372181568784, -122.412798757353) | 10 | 7 | 7 | 28859 | 2 | |||
77457 | 175216 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 240 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010752.32605 | 2091460.28671 | 37.7233580771044 | -122.404944037249 | (37.7233580771044, -122.404944037249) | 10 | 3 | 7 | 309 | 28 | |||
88122 | 248073 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 440 Holladay Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6010194.15796 | 2098463.12553 | 37.7425551682987 | -122.407366975408 | (37.7425551682987, -122.407366975408) | 10 | 7 | 7 | 28859 | 2 | |||
103566 | 248075 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 407 Holladay Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010292.79484 | 2098665.98806 | 37.743117705012 | -122.407040212138 | (37.743117705012, -122.407040212138) | 10 | 7 | 7 | 28859 | 2 | |||
103811 | 189214 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1498 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6014376.75149 | 2102028.72002 | 37.7525787510095 | -122.393154121288 | (37.7525787510095, -122.393154121288) | 10 | 3 | 8 | 28856 | 29 | |||
108759 | 175185 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 526 Lathrop Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012801.34824 | 2086611.11374 | 37.7101575412033 | -122.397520974627 | (37.7101575412033, -122.397520974627) | 10 | 3 | 8 | 309 | 1 | |||
191642 | 202091 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 82 Carr St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6012965.80047 | 2090628.94188 | 37.7211988543156 | -122.397234148441 | (37.7211988543156, -122.397234148441) | 10 | 3 | 8 | 58 | 1 | |||
98506 | 221791 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 867 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/1991 12:00:00 AM | 30 | Width 6ft | Permit Number 29826 | 6010196.62735 | 2104192.74111 | 37.7582875664398 | -122.407762355146 | (37.7582875664398, -122.407762355146) | 10 | 4 | 7 | 28859 | 19 | |
127470 | 189220 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1652 La Salle Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 8ft | 6015291.93207 | 2096384.83865 | 37.737132622377 | -122.389595102843 | (37.737132622377, -122.389595102843) | 10 | 3 | 8 | 58 | 1 | |||
146627 | 175215 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 857 Barneveld Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | Width 8ft | 6010301.67863 | 2094727.33157 | 37.7323034959049 | -122.406731980322 | (37.7323034959049, -122.406731980322) | 10 | 3 | 7 | 309 | 28 |
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) );