trees
45 rows where qSiteInfo = "Sidewalk: Curb side : Yard" and qSpecies_id = 6
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1932 | 250999 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 206 Point Lobos Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5982160.80138 | 2112648.74636 | 37.7798959540729 | -122.505347618625 | (37.7798959540729, -122.505347618625) | 11 | 6 | 2 | 55 | 26 | |||
| 9692 | 183446 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2511 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/08/2020 12:00:00 AM | 3 | Width 0ft | 5988279.6214 | 2098205.3016 | 37.7405963382743 | -122.483121197886 | (37.7405963382743, -122.483121197886) | 1 | 8 | 3 | 29491 | 35 | ||
| 10101 | 180653 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 245 Chicago Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/11/2017 07:56:00 AM | 3 | Width 6ft | 6002847.75966 | 2086772.69306 | 37.7100419513527 | -122.431934068713 | (37.7100419513527, -122.431934068713) | 9 | 7 | 6 | 28861 | 5 | ||
| 27064 | 182564 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2122 Ulloa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | Permit Number 783239 | 5989402.8067 | 2098365.7306 | 37.7411021315374 | -122.479249432397 | (37.7411021315374, -122.479249432397) | 1 | 8 | 3 | 29491 | 35 | ||
| 30385 | 181018 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 197 Rolph St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 11:31:00 AM | 3 | Width 4ft | 6001005.57228 | 2088396.04691 | 37.7143947132291 | -122.43841724089 | (37.7143947132291, -122.43841724089) | 9 | 7 | 6 | 28861 | 5 | ||
| 39381 | 181028 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 95 Rolph St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2017 04:38:00 PM | 3 | Width 4ft | 6000533.08885 | 2088674.46766 | 37.7151323074928 | -122.440070279342 | (37.7151323074928, -122.440070279342) | 9 | 7 | 6 | 28861 | 5 | ||
| 44798 | 184494 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1875 38th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984410.615 | 2102424.5695 | 37.7519553887834 | -122.496809845733 | (37.7519553887834, -122.496809845733) | 1 | 8 | 3 | 56 | 35 | |||
| 48766 | 207033 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Quintara St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993145.27059 | 2101214.49823 | 37.7491407714503 | -122.466516461993 | (37.7491407714503, -122.466516461993) | 1 | 8 | 4 | 29491 | 12 | |||
| 51774 | 184549 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3501 Moraga St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5983411.1343 | 2103548.3965 | 37.754982490057 | -122.500349218821 | (37.754982490057, -122.500349218821) | 1 | 8 | 3 | 56 | 35 | |||
| 59117 | 184544 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3425 Moraga St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 03/06/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781517 | 5983632.4928 | 2103556.7404 | 37.7550183908439 | -122.499584326949 | (37.7550183908439, -122.499584326949) | 1 | 8 | 3 | 56 | 35 | |
| 70068 | 207041 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1414 Plymouth Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5995889.45634 | 2093373.14104 | 37.727768297568 | -122.456460143934 | (37.727768297568, -122.456460143934) | 9 | 7 | 4 | 28861 | 40 | |||
| 72364 | 216718 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 978 Capitol Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/13/2017 11:36:00 AM | 3 | Width 3ft | 5995057.03199 | 2090421.24862 | 37.7196152839906 | -122.459124173263 | (37.7196152839906, -122.459124173263) | 9 | 8 | 6 | 28861 | 24 | ||
| 72800 | 121883 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 18th Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 5990230.48175 | 2114847.31405 | 37.786404156248 | -122.477592056385 | (37.786404156248, -122.477592056385) | 11 | 6 | 1 | 55 | 33 | |||
| 80376 | 184160 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3538 Lawton St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/28/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781479 | 5983222.1931 | 2104276.0104 | 37.7569692214498 | -122.50105643195 | (37.7569692214498, -122.50105643195) | 1 | 8 | 3 | 56 | 35 | |
| 81876 | 227086 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 6009619.77164 | 2096165.81934 | 37.7362150980513 | -122.409190969587 | (37.7362150980513, -122.409190969587) | 10 | 7 | 7 | 28859 | 2 | |||
| 82053 | 121884 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 18th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 5990230.57834 | 2114834.81932 | 37.7863698548312 | -122.477590808601 | (37.7863698548312, -122.477590808601) | 11 | 6 | 1 | 55 | 33 | |||
| 83192 | 227092 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 30 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 9ft | 6009197.49082 | 2095788.04823 | 37.7351541534232 | -122.410624304588 | (37.7351541534232, -122.410624304588) | 10 | 7 | 7 | 28859 | 2 | |||
| 83985 | 227091 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 29 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 5ft | 6009293.03444 | 2095834.73547 | 37.735287702767 | -122.410297269721 | (37.735287702767, -122.410297269721) | 10 | 7 | 7 | 28859 | 2 | |||
| 85415 | 207038 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 270 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5994641.46146 | 2100307.89339 | 37.7467376875983 | -122.461276941602 | (37.7467376875983, -122.461276941602) | 1 | 8 | 4 | 29491 | 40 | |||
| 87952 | 207035 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Quintara St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993108.07657 | 2101214.12996 | 37.7491376139164 | -122.466645051533 | (37.7491376139164, -122.466645051533) | 1 | 8 | 4 | 29491 | 12 | |||
| 93370 | 255421 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2727 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780223 | 5985829 | 2096861 | 37.7367623321138 | -122.491495459369 | (37.7367623321138, -122.491495459369) | 1 | 8 | 3 | 29491 | 35 | |
| 98535 | 227088 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 5ft | 6009533.30641 | 2096029.17809 | 37.7358350661275 | -122.409480276115 | (37.7358350661275, -122.409480276115) | 10 | 7 | 7 | 28859 | 2 | |||
| 109143 | 181019 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 191 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 12:36:00 PM | 3 | Width 4ft | 6000981.45407 | 2088409.26942 | 37.7144296473919 | -122.438501549606 | (37.7144296473919, -122.438501549606) | 9 | 7 | 6 | 28861 | 5 | ||
| 110146 | 227090 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 22 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6009411.625 | 2095915.20486 | 37.7355153013828 | -122.409892935407 | (37.7355153013828, -122.409892935407) | 10 | 7 | 7 | 28859 | 2 | |||
| 111414 | 227548 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 290 Jersey St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6003268.76291 | 2101573.30364 | 37.7507049460775 | -122.431534930712 | (37.7507049460775, -122.431534930712) | 2 | 4 | 5 | 28862 | 22 | |||
| 117385 | 181020 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 183 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 12:41:00 PM | 3 | Width 4ft | 6000952.49174 | 2088426.93011 | 37.7144764921819 | -122.438602919392 | (37.7144764921819, -122.438602919392) | 9 | 7 | 6 | 28861 | 5 | ||
| 129549 | 184161 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3540 Lawton St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/28/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781479 | 5983209.359 | 2104274.4825 | 37.7569642726582 | -122.501100703383 | (37.7569642726582, -122.501100703383) | 1 | 8 | 3 | 56 | 35 | |
| 133452 | 181027 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 95 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2017 04:23:00 PM | 3 | Width 4ft | 6000546.58685 | 2088667.24811 | 37.7151132526545 | -122.440023107188 | (37.7151132526545, -122.440023107188) | 9 | 7 | 6 | 28861 | 5 | ||
| 139625 | 184669 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1679 37th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 01/03/2019 12:00:00 AM | 3 | Width 0ft | Permit Number 782746 | 5984671.7436 | 2103779.4399 | 37.7556907855566 | -122.496006782875 | (37.7556907855566, -122.496006782875) | 1 | 8 | 3 | 56 | 35 | |
| 140576 | 207034 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Quintara St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993127.03688 | 2101215.11136 | 37.7491414027515 | -122.466579558421 | (37.7491414027515, -122.466579558421) | 1 | 8 | 4 | 29491 | 12 | |||
| 145000 | 227089 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 17 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 6009456.29094 | 2095946.49023 | 37.7356037074354 | -122.409740715285 | (37.7356037074354, -122.409740715285) | 10 | 7 | 7 | 28859 | 2 | |||
| 145011 | 117426 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 395 Athens St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 775297 | 6003998.92006 | 2091015.17385 | 37.7217560742586 | -122.428257595231 | (37.7217560742586, -122.428257595231) | 9 | 7 | 6 | 28861 | 5 | ||
| 147718 | 201819 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | 6021071.50009 | 2093300.77069 | 37.7289831323462 | -122.369399226393 | (37.7289831323462, -122.369399226393) | 10 | 3 | 8 | 58 | 1 | ||
| 148726 | 227093 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 31 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 9ft | 6009184.48132 | 2095791.05398 | 37.7351616771725 | -122.410669495512 | (37.7351616771725, -122.410669495512) | 10 | 7 | 7 | 28859 | 2 | |||
| 149415 | 201820 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | 6021056.53291 | 2093279.09213 | 37.7289227860515 | -122.369449472416 | (37.7289227860515, -122.369449472416) | 10 | 3 | 8 | 58 | 1 | ||
| 158809 | 184688 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1611 37th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 01/03/2019 12:00:00 AM | 3 | Width 0ft | Permit Number 782745 | 5984657.9281 | 2104207.7196 | 37.7568659135367 | -122.496086155975 | (37.7568659135367, -122.496086155975) | 1 | 8 | 3 | 56 | 35 | |
| 159328 | 201821 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | 6021045.51426 | 2093266.44708 | 37.7288874606638 | -122.369486691782 | (37.7288874606638, -122.369486691782) | 10 | 3 | 8 | 58 | 1 | ||
| 164477 | 227094 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 35 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6009153.63089 | 2095762.56962 | 37.7350817355269 | -122.410774146024 | (37.7350817355269, -122.410774146024) | 10 | 7 | 7 | 28859 | 2 | ||||
| 168066 | 181011 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 207 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 11:21:00 AM | 3 | Width 4ft | 6001121.31583 | 2088326.00254 | 37.7142089699327 | -122.438012171843 | (37.7142089699327, -122.438012171843) | 9 | 7 | 6 | 28861 | 5 | ||
| 176832 | 207039 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 270 Magellan Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5994635.03268 | 2100302.9111 | 37.7467236374953 | -122.461298810415 | (37.7467236374953, -122.461298810415) | 1 | 8 | 4 | 29491 | 40 | |||
| 181063 | 182513 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1573 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 03/23/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 777985 | 5985578.9968 | 2104511.5721 | 37.7577541150318 | -122.492923184352 | (37.7577541150318, -122.492923184352) | 1 | 8 | 3 | 56 | 35 | |
| 184554 | 201822 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | 6021035.49669 | 2093250.02992 | 37.7288418326792 | -122.369520189723 | (37.7288418326792, -122.369520189723) | 10 | 3 | 8 | 58 | 1 | ||
| 187202 | 183640 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1484 47th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5981572.1323 | 2104991.2828 | 37.7588361283195 | -122.506815916291 | (37.7588361283195, -122.506815916291) | 1 | 8 | 3 | 56 | 35 | |||
| 192989 | 181010 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 215 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 11:17:00 AM | 3 | Width 4ft | 6001139.6561 | 2088316.90059 | 37.7141850209845 | -122.437948129327 | (37.7141850209845, -122.437948129327) | 9 | 7 | 6 | 28861 | 5 | ||
| 194177 | 181017 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 197 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 11:28:00 AM | 3 | Width 4ft | 6001019.31887 | 2088386.79799 | 37.7143700996689 | -122.438369065102 | (37.7143700996689, -122.438369065102) | 9 | 7 | 6 | 28861 | 5 |
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) );