trees
246 rows where qSpecies_id = 20 sorted by YCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 176947 | 130433 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 550 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6004538.94577 | 2111043.55474 | 37.776779903004 | -122.427817240371 | (37.776779903004, -122.427817240371) | 7 | 9 | 11 | 28852 | 10 | |||
| 159123 | 1680 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 400 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/1998 12:00:00 AM | 12 | 3X3 | 5994348.50119 | 2111464.79497 | 37.7773547778944 | -122.463099340943 | (37.7773547778944, -122.463099340943) | 11 | 6 | 2 | 54 | 11 | ||
| 190537 | 123699 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 302 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994616.48583 | 2111473.74211 | 37.777394777876 | -122.462172950615 | (37.777394777876, -122.462172950615) | 11 | 6 | 2 | 54 | 11 | |||
| 179310 | 42243 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 547 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42492 | 6010057.93942853 | 2111817.75656126 | 37.7792163405696 | -122.408779938797 | (37.7792163405696, -122.408779938797) | 14 | 2 | 9 | 28853 | 34 | ||
| 189499 | 42244 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 547 Natoma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42492 | 6010057.93942853 | 2111817.75656126 | 37.7792163405696 | -122.408779938797 | (37.7792163405696, -122.408779938797) | 14 | 2 | 9 | 28853 | 34 | ||
| 60221 | 50521 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 145 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 1 | Permit Number 47159 | 5996798.3759 | 2112040.3174 | 37.7790758310411 | -122.454666063431 | (37.7790758310411, -122.454666063431) | 15 | 6 | 2 | 54 | 16 | |
| 160538 | 17695 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1100X Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2004 12:00:00 AM | 3 | 3X3 | 6002388.932052 | 2112303.174651 | 37.7801166436013 | -122.435344894499 | (37.7801166436013, -122.435344894499) | 15 | 5 | 11 | 29490 | 41 | ||
| 79567 | 137580 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1150 PIERCE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6002381.2868 | 2112341.0686 | 37.7802202566686 | -122.435374054285 | (37.7802202566686, -122.435374054285) | 15 | 5 | 11 | 29490 | 41 | |||
| 159254 | 38335 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 444 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2017 12:00:00 AM | 3 | Permit Number 47950 | 5983475.92441 | 2112817.71297 | 37.7804371865901 | -122.500810595919 | (37.7804371865901, -122.500810595919) | 11 | 6 | 2 | 55 | 26 | ||
| 81612 | 117729 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 444 40th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5983475.64973 | 2112834.36493 | 37.7804828918797 | -122.500812777933 | (37.7804828918797, -122.500812777933) | 11 | 6 | 2 | 55 | 26 | |||
| 49315 | 141042 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 175 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5996531.5303 | 2113164.047 | 37.7821459864366 | -122.45567043332 | (37.7821459864366, -122.45567043332) | 11 | 6 | 1 | 54 | 31 | |||
| 109450 | 68582 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 175 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1993 12:00:00 AM | 4 | Permit Number 32479 | 5996530.1767 | 2113176.907 | 37.7821812189094 | -122.455676045985 | (37.7821812189094, -122.455676045985) | 11 | 6 | 1 | 54 | 31 | ||
| 52550 | 38836 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 254 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1998 12:00:00 AM | Permit Number 40666 | 5994768.12752284 | 2113559.99820217 | 37.7831318083177 | -122.461799686207 | (37.7831318083177, -122.461799686207) | 11 | 6 | 2 | 54 | 11 | ||
| 149416 | 38837 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 254 Clement St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1998 12:00:00 AM | Permit Number 40666 | 5994768.12752284 | 2113559.99820217 | 37.7831318083177 | -122.461799686207 | (37.7831318083177, -122.461799686207) | 11 | 6 | 2 | 54 | 11 | ||
| 160681 | 38834 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 254 Clement St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1998 12:00:00 AM | Permit Number 40666 | 5994768.12752284 | 2113559.99820217 | 37.7831318083177 | -122.461799686207 | (37.7831318083177, -122.461799686207) | 11 | 6 | 2 | 54 | 11 | ||
| 121565 | 123605 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 288 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994650.61525 | 2113597.37697 | 37.78322767487 | -122.462208939817 | (37.78322767487, -122.462208939817) | 11 | 6 | 2 | 54 | 11 | |||
| 49263 | 123604 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 288 04th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994649.79815 | 2113605.55206 | 37.7832500744158 | -122.462212359722 | (37.7832500744158, -122.462212359722) | 11 | 6 | 2 | 54 | 11 | |||
| 70046 | 40802 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 121 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1999 12:00:00 AM | 4 | Permit Number 41751 | 5996513.2556 | 2113630.7306 | 37.7834263270019 | -122.455767400466 | (37.7834263270019, -122.455767400466) | 11 | 6 | 1 | 54 | 31 | ||
| 30320 | 110153 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 267 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775195 | 5988018.8 | 2114202.3 | 37.7845045397665 | -122.485196475776 | (37.7845045397665, -122.485196475776) | 11 | 6 | 2 | 55 | 26 | |
| 102327 | 36962 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 146 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 7 | Permit Number 39591 | 5994303.22649 | 2114557.05479 | 37.785842681857 | -122.463480424277 | (37.785842681857, -122.463480424277) | 11 | 6 | 1 | 54 | 11 | |
| 25917 | 123969 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 115 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993630.62281 | 2114735.81846 | 37.7862947425232 | -122.46582041968 | (37.7862947425232, -122.46582041968) | 11 | 6 | 2 | 54 | 11 | |||
| 53984 | 45168 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2695 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2001 12:00:00 AM | Permit Number 44017 | 6001924.94764161 | 2115681.1327225 | 37.7893652944435 | -122.437191954251 | (37.7893652944435, -122.437191954251) | 13 | 6 | 1 | 29490 | 27 | |||
| 64634 | 45170 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2695 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2001 12:00:00 AM | Permit Number 44017 | 6001924.94764161 | 2115681.1327225 | 37.7893652944435 | -122.437191954251 | (37.7893652944435, -122.437191954251) | 13 | 6 | 1 | 29490 | 27 | |||
| 140173 | 45167 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2695 Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2001 12:00:00 AM | Permit Number 44017 | 6001924.94764161 | 2115681.1327225 | 37.7893652944435 | -122.437191954251 | (37.7893652944435, -122.437191954251) | 13 | 6 | 1 | 29490 | 27 | |||
| 151888 | 45169 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2695 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2001 12:00:00 AM | Permit Number 44017 | 6001924.94764161 | 2115681.1327225 | 37.7893652944435 | -122.437191954251 | (37.7893652944435, -122.437191954251) | 13 | 6 | 1 | 29490 | 27 | |||
| 85882 | 18881 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2323 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/2009 12:00:00 AM | 3 | 2X2 | 6003542.78856 | 2115901.08421 | 37.7900610577291 | -122.431610123004 | (37.7900610577291, -122.431610123004) | 13 | 9 | 1 | 29490 | 27 | ||
| 8722 | 130434 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2701 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001177.09215 | 2116887.43491 | 37.7926349471062 | -122.439865967752 | (37.7926349471062, -122.439865967752) | 13 | 6 | 1 | 29490 | 27 | |||
| 58828 | 110905 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2891 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2015 12:00:00 AM | 3 | 3x10 | Permit Number 775210 | 5999766.16076 | 2117386.55705 | 37.7939249895015 | -122.444783719687 | (37.7939249895015, -122.444783719687) | 13 | 9 | 1 | 57 | 27 | |
| 52323 | 130435 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2127 Broadway | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6003305.56754 | 2117513.80582 | 37.7944757298119 | -122.432546129322 | (37.7944757298119, -122.432546129322) | 13 | 9 | 1 | 29490 | 27 | |||
| 64224 | 130432 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2824 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999398.65268 | 2118424.75751 | 37.7967546325742 | -122.446130041675 | (37.7967546325742, -122.446130041675) | 13 | 9 | 1 | 57 | 17 | |||
| 20359 | 111160 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 99X Magnolia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003321.77346 | 2119803.50555 | 37.8007635719416 | -122.432653690929 | (37.8007635719416, -122.432653690929) | 13 | 9 | 1 | 57 | 17 | |||
| 117311 | 111161 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 99X Magnolia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003338.31122 | 2119805.54449 | 37.8007701082019 | -122.432596609162 | (37.8007701082019, -122.432596609162) | 13 | 9 | 1 | 57 | 17 | |||
| 137511 | 111162 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 99X Magnolia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6003355.09781 | 2119808.05454 | 37.8007779520905 | -122.4325387 | (37.8007779520905, -122.4325387) | 13 | 9 | 1 | 57 | 17 | |||
| 107681 | 111163 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 99X Magnolia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6003374.28365 | 2119810.99129 | 37.8007871036097 | -122.432472518919 | (37.8007871036097, -122.432472518919) | 13 | 9 | 1 | 57 | 17 | |||
| 35594 | 111164 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 99X Magnolia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6003392.25539 | 2119813.00098 | 37.8007936407819 | -122.432410472862 | (37.8007936407819, -122.432410472862) | 13 | 9 | 1 | 57 | 17 | |||
| 126173 | 111165 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 99X Magnolia St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6003411.20248 | 2119815.94235 | 37.8008027913768 | -122.432345118256 | (37.8008027913768, -122.432345118256) | 13 | 9 | 1 | 57 | 17 | |||
| 141863 | 130437 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2201 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007591.42221 | 2119948.52727 | 37.8014029764228 | -122.417889178244 | (37.8014029764228, -122.417889178244) | 5 | 1 | 1 | 28858 | 32 | |||
| 11239 | 260905 | Private 9 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2211 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2019 12:00:00 AM | 3 | 2X3 | 6007589.07412 | 2119959.01259 | 37.8014316343257 | -122.417898047397 | (37.8014316343257, -122.417898047397) | 5 | 1 | 1 | 28858 | 32 | ||
| 13810 | 115990 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2211 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2016 12:00:00 AM | 3 | 2x4 | Permit Number 777665 | 6007568.4 | 2119969.3 | 37.8014587174384 | -122.417970318963 | (37.8014587174384, -122.417970318963) | 5 | 1 | 1 | 28858 | 32 | |
| 103779 | 115991 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2211 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2016 12:00:00 AM | 3 | 2x4 | Permit Number 777665 | 6007568.4 | 2119969.3 | 37.8014587174384 | -122.417970318963 | (37.8014587174384, -122.417970318963) | 5 | 1 | 1 | 28858 | 32 | |
| 42561 | 130436 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2201 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007584.36539 | 2119972.20513 | 37.8014675927187 | -122.417915277469 | (37.8014675927187, -122.417915277469) | 5 | 1 | 1 | 28858 | 32 | |||
| 12190 | 260906 | Private 9 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2215 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2019 12:00:00 AM | 3 | 2X3 | 6007586.25473 | 2119982.21322 | 37.8014951787433 | -122.417909449339 | (37.8014951787433, -122.417909449339) | 5 | 1 | 1 | 28858 | 32 | ||
| 169767 | 48596 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2828 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2002 12:00:00 AM | Permit Number 45906 | 6006109.55880525 | 2120479.22122038 | 37.8027766188477 | -122.423054835322 | (37.8027766188477, -122.423054835322) | 5 | 9 | 1 | 28858 | 32 | ||
| 175958 | 13062 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 590 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2000 12:00:00 AM | 6 | 2X2 | 6009500.6409 | 2120545.5727 | 37.8031495768645 | -122.411324605789 | (37.8031495768645, -122.411324605789) | 3 | 1 | 10 | 308 | 23 | ||
| 130355 | 12993 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 330 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2005 12:00:00 AM | 3 | 3X3 | 6010724.12169 | 2120710.34518 | 37.8036705448693 | -122.407102317839 | (37.8036705448693, -122.407102317839) | 3 | 1 | 10 | 308 | 23 | ||
| 5802 | 62147 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2057 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/1985 12:00:00 AM | 3 | Permit Number 22261 | 5999361.52655 | 2121151.92571 | 37.8042405839018 | -122.446454803956 | (37.8042405839018, -122.446454803956) | 13 | 9 | 1 | 57 | 17 |
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) );