trees
121 rows where qSpecies_id = 82 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
59272 | 177484 | DPW Maintained 1 | Malus :: Crab Apple 82 | 214 Athens St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6004659.61687 | 2092165.75361 | 37.7249526758206 | -122.426055604304 | (37.7249526758206, -122.426055604304) | 9 | 7 | 6 | 28861 | 5 | ||||
102324 | 44446 | DPW Maintained 1 | Malus :: Crab Apple 82 | 59 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776702 | 6002663.70845 | 2086958.55404 | 37.7105418493914 | -122.432583452082 | (37.7105418493914, -122.432583452082) | 9 | 7 | 6 | 28861 | 5 | |
104025 | 177473 | DPW Maintained 1 | Malus :: Crab Apple 82 | 661 London St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6001084.39959 | 2089950.75515 | 37.7186680775449 | -122.438256094064 | (37.7186680775449, -122.438256094064) | 9 | 7 | 6 | 28861 | 5 | ||||
187628 | 177483 | DPW Maintained 1 | Malus :: Crab Apple 82 | 37 Vienna St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6005099.05752 | 2093268.21852 | 37.7280046286024 | -122.424614893969 | (37.7280046286024, -122.424614893969) | 9 | 7 | 6 | 28861 | 5 | ||||
21017 | 111270 | DPW Maintained 1 | Malus :: Crab Apple 82 | 700X BOSWORTH ST | 8 | Front Yard : Yard | Tree | DPW 1 | 10 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
22243 | 231467 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1100 San Jose Ave | 54 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6004723.8665 | 2096633.35194 | 37.7372233360818 | -122.426151410869 | (37.7372233360818, -122.426151410869) | 2 | 7 | 5 | 63 | 7 | ||||
30178 | 231494 | DPW Maintained 1 | Malus :: Crab Apple 82 | 339 Addison St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6002235.98479 | 2097691.64052 | 37.7399882198726 | -122.434828804717 | (37.7399882198726, -122.434828804717) | 2 | 7 | 5 | 63 | 7 | |||
36521 | 231492 | DPW Maintained 1 | Malus :: Crab Apple 82 | 118 Saint Marys Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6003928.90104 | 2095975.35964 | 37.7353716742659 | -122.428853075008 | (37.7353716742659, -122.428853075008) | 2 | 7 | 5 | 63 | 7 | |||
47430 | 231469 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1100 San Jose Ave | 56 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6004732.5768 | 2096627.96754 | 37.7372090440461 | -122.426120912148 | (37.7372090440461, -122.426120912148) | 2 | 7 | 5 | 63 | 7 | ||||
108858 | 231491 | DPW Maintained 1 | Malus :: Crab Apple 82 | 231 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001952.57165 | 2096161.99375 | 37.7357720695123 | -122.435699318774 | (37.7357720695123, -122.435699318774) | 2 | 7 | 5 | 63 | 7 | |||
116776 | 231468 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1100 San Jose Ave | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6004726.49867 | 2096628.95996 | 37.7372114254688 | -122.426141997667 | (37.7372114254688, -122.426141997667) | 2 | 7 | 5 | 63 | 7 | ||||
119727 | 231493 | DPW Maintained 1 | Malus :: Crab Apple 82 | 339 Addison St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6002237.63018 | 2097698.28157 | 37.7400065480711 | -122.434823590441 | (37.7400065480711, -122.434823590441) | 2 | 7 | 5 | 63 | 7 | |||
141816 | 231495 | DPW Maintained 1 | Malus :: Crab Apple 82 | 339 Addison St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6002243.19948 | 2097700.16893 | 37.7400120465212 | -122.434804469057 | (37.7400120465212, -122.434804469057) | 2 | 7 | 5 | 63 | 7 | |||
142430 | 231470 | DPW Maintained 1 | Malus :: Crab Apple 82 | 200 Saint Marys Ave | 4 | Side Yard : Yard | Tree | Private 2 | 5 | Width 2ft | 6003936.80205 | 2095969.7041 | 37.7353565926307 | -122.42882535522 | (37.7353565926307, -122.42882535522) | 2 | 7 | 5 | 63 | 7 | |||
152179 | 231490 | DPW Maintained 1 | Malus :: Crab Apple 82 | 144 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004625.22033 | 2097267.44339 | 37.7389588315807 | -122.42653761393 | (37.7389588315807, -122.42653761393) | 2 | 7 | 5 | 63 | 7 | |||
173142 | 4977 | DPW Maintained 1 | Malus :: Crab Apple 82 | 5200X Diamond Heights Blvd | 13 | Median : Cutout | Tree | DPW 1 | 12 | 12 | 6000986.47805 | 2099376.03086 | 37.7445421376042 | -122.439269772981 | (37.7445421376042, -122.439269772981) | 2 | 7 | 5 | 63 | 7 | |||
31426 | 244062 | DPW Maintained 1 | Malus :: Crab Apple 82 | 1666 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998622.1807 | 2109013.5796 | 37.7708696265101 | -122.448138811863 | (37.7708696265101, -122.448138811863) | 15 | 5 | 11 | 29492 | 9 | |||
58094 | 244485 | DPW Maintained 1 | Malus :: Crab Apple 82 | 201 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6001267.601 | 2109451.913 | 37.7722240530146 | -122.43901967935 | (37.7722240530146, -122.43901967935) | 15 | 5 | 11 | 29492 | 9 | |||
108554 | 16982 | DPW Maintained 1 | Malus :: Crab Apple 82 | 845 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2002 12:00:00 AM | 2 | 3X3 | 6002950.3496 | 2109907.5532 | 37.7735707302623 | -122.433231473927 | (37.7735707302623, -122.433231473927) | 15 | 5 | 11 | 29492 | 9 | ||
143487 | 247172 | DPW Maintained 1 | Malus :: Crab Apple 82 | 145 Buena Vista Ave East | 3 | : | Tree | Private 2 | 1 | Width 4ft | 6001372.05344 | 2108496.34434 | 37.7696062421579 | -122.438589890015 | (37.7696062421579, -122.438589890015) | 15 | 5 | 5 | 29492 | 9 | |||
155688 | 248559 | DPW Maintained 1 | Malus :: Crab Apple 82 | 776 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998007.1271 | 2107705.5553 | 37.7672429465083 | -122.450171990254 | (37.7672429465083, -122.450171990254) | 15 | 5 | 11 | 29492 | 9 |
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) );