trees
27 rows where DBH = 14, qLegalStatus_id = 1 and qSpecies_id = 65 sorted by PlotSize
This data as json, CSV (advanced)
Suggested facets: SiteOrder
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1937 | 78248 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 734 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6002539.24351 | 2089283.26415 | 37.716917933889 | -122.433179625239 | (37.716917933889, -122.433179625239) | 9 | 7 | 6 | 28861 | 5 | |||
| 15128 | 70636 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 249 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 5989603.89345 | 2113698.71942 | 37.7832140576516 | -122.479675795688 | (37.7832140576516, -122.479675795688) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |
| 30708 | 175201 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 648 Peru Ave | 7 | Side Yard : Yard | Tree | Private 2 | 14 | 6005063.1365 | 2092591.26253 | 37.7261438278596 | -122.424690937041 | (37.7261438278596, -122.424690937041) | 9 | 7 | 6 | 28861 | 5 | ||||
| 43175 | 38227 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1099 Mississippi St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | 14 | Permit Number 40351 | 6014264.01456 | 2102105.05687 | 37.7527820922208 | -122.393549330162 | (37.7527820922208, -122.393549330162) | 10 | 3 | 8 | 28856 | 29 | ||
| 46915 | 38203 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 691 Goettingen St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | 14 | Permit Number 40328 | 6010707.71448 | 2091513.67595 | 37.7235021790704 | -122.405102009451 | (37.7235021790704, -122.405102009451) | 10 | 3 | 7 | 309 | 28 | |
| 77208 | 37072 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1426 43rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 14 | Permit Number 39847 | 5982799.9219 | 2105403.4894 | 37.7600401558558 | -122.502600230953 | (37.7600401558558, -122.502600230953) | 1 | 8 | 3 | 56 | 35 | |
| 99540 | 124272 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2 03rd Ave | 1 | Front Yard : Yard | Tree | Private 2 | 14 | 5994894.05661 | 2114999.9706 | 37.787092832167 | -122.46146845316 | (37.787092832167, -122.46146845316) | 11 | 6 | 1 | 54 | 11 | ||||
| 164826 | 66782 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1001 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | 14 | Permit Number 30052 | 6006921.4512 | 2120474.40868 | 37.8028091860666 | -122.420244926256 | (37.8028091860666, -122.420244926256) | 5 | 1 | 1 | 28858 | 32 | |
| 175001 | 124270 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2 03rd Ave | 3 | Front Yard : Yard | Tree | Private 2 | 14 | 5994893.51688 | 2115041.88961 | 37.78720789934 | -122.461473360648 | (37.78720789934, -122.461473360648) | 11 | 6 | 1 | 54 | 11 | ||||
| 18137 | 70176 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 307 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 3.5x4 to 3.5x7 | 6004287.81152 | 2091470.53201 | 37.7230227297861 | -122.42729139329 | (37.7230227297861, -122.42729139329) | 9 | 7 | 6 | 28861 | 5 | ||
| 92411 | 244965 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 250 Lily St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005276.5809 | 2110102.9361 | 37.7742388930949 | -122.42519859053 | (37.7742388930949, -122.42519859053) | 7 | 9 | 11 | 28852 | 10 | |||
| 130358 | 247338 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 220 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6002315.9732 | 2109334.9211 | 37.7719624169971 | -122.435384903619 | (37.7719624169971, -122.435384903619) | 15 | 5 | 11 | 29492 | 9 | |||
| 93508 | 203530 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 355 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5995608.47907 | 2092372.56646 | 37.7250048247995 | -122.457359125149 | (37.7250048247995, -122.457359125149) | 9 | 7 | 4 | 28861 | 40 | |||
| 159787 | 203555 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Farallones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5994968.99544 | 2088379.28856 | 37.7140034838548 | -122.459280689461 | (37.7140034838548, -122.459280689461) | 9 | 8 | 6 | 28861 | 24 | |||
| 186585 | 175207 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 9 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6005359.84242 | 2093211.49837 | 37.7278636122004 | -122.423709320725 | (37.7278636122004, -122.423709320725) | 9 | 7 | 6 | 28861 | 5 | |||
| 41894 | 221832 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 573 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007293.28891 | 2103997.59658 | 37.7575887842104 | -122.417789563935 | (37.7575887842104, -122.417789563935) | 2 | 4 | 7 | 28859 | 19 | |||
| 47768 | 221885 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 100 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008227.02437 | 2099369.61702 | 37.7449338966774 | -122.414232888254 | (37.7449338966774, -122.414232888254) | 2 | 7 | 7 | 28859 | 2 | |||
| 93867 | 189215 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1400 20th St | 2 | : | Tree | Private 2 | 14 | Width 3ft | 6013696.29673 | 2104791.67795 | 37.7601274111746 | -122.395700842123 | (37.7601274111746, -122.395700842123) | 10 | 3 | 8 | 28856 | 29 | |||
| 99508 | 221835 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 585 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007295.48201 | 2103941.69106 | 37.7574354039359 | -122.41777801665 | (37.7574354039359, -122.41777801665) | 2 | 4 | 7 | 28859 | 19 | |||
| 135296 | 221865 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 592 Laidley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002930.8792 | 2095923.87336 | 37.7351737658507 | -122.432299929108 | (37.7351737658507, -122.432299929108) | 2 | 7 | 5 | 63 | 7 | |||
| 162952 | 221836 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 585 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007298.30885 | 2103900.40234 | 37.7573221936904 | -122.417765313729 | (37.7573221936904, -122.417765313729) | 2 | 4 | 7 | 28859 | 19 | |||
| 130024 | 221936 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 48 Harper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6003658.55433 | 2098021.59816 | 37.7409748723836 | -122.429933678794 | (37.7409748723836, -122.429933678794) | 2 | 7 | 5 | 63 | 7 | |||
| 144210 | 122028 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4200 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5990335.88311 | 2109958.87683 | 37.7729879776993 | -122.476870087567 | (37.7729879776993, -122.476870087567) | 11 | 6 | 2 | 55 | 26 | |||
| 193967 | 125548 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1445 Greenwich St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6006007.30583 | 2119647.97872 | 37.8004884684307 | -122.423349556855 | (37.8004884684307, -122.423349556855) | 13 | 9 | 1 | 28858 | 32 | |||
| 159038 | 221793 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 26 Norwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6009169.37019 | 2099491.8572 | 37.745322428991 | -122.410983048655 | (37.745322428991, -122.410983048655) | 2 | 7 | 7 | 28859 | 2 | |||
| 46307 | 203579 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 312 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 6ft | 5999939.25303 | 2094981.39881 | 37.7324158679899 | -122.44257538767 | (37.7324158679899, -122.44257538767) | 9 | 7 | 4 | 63 | 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) );