trees
7,322 rows where qSpecies_id = 1 sorted by Police Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 93455 | 143490 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/24/2016 08:48:00 AM | 0 | Width 0ft | 6010035.0683 | 2119214.1514 | 37.7995237814105 | -122.409381180174 | (37.7995237814105, -122.409381180174) | 3 | 1 | 10 | 308 | 4 | ||
| 94337 | 251270 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 853 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2017 12:00:00 AM | 3 | 3x3 | 6008278.12362 | 2120317.86249 | 37.8024557006055 | -122.415539041664 | (37.8024557006055, -122.415539041664) | 5 | 1 | 10 | 308 | 32 | ||
| 94939 | 136894 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1136 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007527.55421 | 2118870.77791 | 37.7984401527358 | -122.418033743385 | (37.7984401527358, -122.418033743385) | 5 | 1 | 10 | 28858 | 32 | |||
| 97509 | 29738 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 656 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2006 12:00:00 AM | 6 | 3x3 | 6009848.564 | 2119190.8307 | 37.7994492972084 | -122.410024907374 | (37.7994492972084, -122.410024907374) | 3 | 1 | 10 | 308 | 4 | ||
| 98961 | 43037 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150 California St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2000 12:00:00 AM | 4 | Permit Number 42896 | 6013102.02461 | 2116950.86058 | 37.7934806821406 | -122.398609430393 | (37.7934806821406, -122.398609430393) | 4 | 1 | 10 | 28860 | 6 | ||
| 100609 | 136902 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2213 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008039.36395 | 2120205.32059 | 37.8021332654887 | -122.41635729467 | (37.8021332654887, -122.41635729467) | 5 | 1 | 10 | 308 | 32 | |||
| 101890 | 9940 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600X Green St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/24/2016 08:48:00 AM | 3 | 6X6 | 6010123.5350709 | 2119222.6779084 | 37.799552149361 | -122.409075654051 | (37.799552149361, -122.409075654051) | 3 | 1 | 10 | 308 | 23 | ||
| 104410 | 142922 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 465 GREEN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010790.8559 | 2119269.8876 | 37.7997191359575 | -122.406769801504 | (37.7997191359575, -122.406769801504) | 3 | 1 | 10 | 308 | 23 | |||
| 104707 | 41774 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1346 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | 10 | Permit Number 42189 | 6007525.74917 | 2115810.14377 | 37.7900363092808 | -122.417822924306 | (37.7900363092808, -122.417822924306) | 13 | 1 | 10 | 28858 | 21 | |
| 106314 | 88404 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1150 Hyde St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51381 | 6007655 | 2116328 | 37.7914654879488 | -122.417412441264 | (37.7914654879488, -122.417412441264) | 5 | 1 | 10 | 28858 | 21 | |||
| 106658 | 136908 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1354 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6011043.96779 | 2119574.14237 | 37.8005687041424 | -122.405915381517 | (37.8005687041424, -122.405915381517) | 3 | 1 | 10 | 308 | 23 | |||
| 106919 | 136845 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 735 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6009182.87639 | 2115503.41096 | 37.7892872126772 | -122.41206769487 | (37.7892872126772, -122.41206769487) | 5 | 1 | 10 | 28858 | 21 | |||
| 108405 | 136875 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 841 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009130.09506 | 2115881.36858 | 37.7903220310813 | -122.412277037259 | (37.7903220310813, -122.412277037259) | 5 | 1 | 10 | 28858 | 21 | |||
| 108537 | 35611 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1534 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38969 | 6007396.3053002 | 2116819.76533741 | 37.7928011953236 | -122.418342405613 | (37.7928011953236, -122.418342405613) | 5 | 1 | 10 | 28858 | 32 | |||
| 108796 | 143088 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 614 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6009954.5993 | 2120247.1152 | 37.8023555364086 | -122.40973258446 | (37.8023555364086, -122.40973258446) | 3 | 1 | 10 | 308 | 23 | |||
| 110113 | 45789 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1320 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51739 | 6011061.04232 | 2119446.90948 | 37.8002203085803 | -122.40584732891 | (37.8002203085803, -122.40584732891) | 3 | 1 | 10 | 308 | 23 | |
| 110671 | 33971 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250 Columbus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1997 12:00:00 AM | Permit Number 37917 | 6007661.76235911 | 2121488.31416717 | 37.8056348004683 | -122.417754973992 | (37.8056348004683, -122.417754973992) | 5 | 1 | 10 | 308 | 23 | |||
| 111593 | 52583 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1047 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2006 12:00:00 AM | 4 | 3x3 | Permit Number 48677 | 6009673.58749 | 2117095.63602 | 37.7936865972027 | -122.410482362785 | (37.7936865972027, -122.410482362785) | 3 | 1 | 10 | 28857 | 21 | |
| 112816 | 143016 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 655 CHESTNUT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6008680.5233 | 2120713.7091 | 37.8035652065716 | -122.414174557157 | (37.8035652065716, -122.414174557157) | 3 | 1 | 10 | 308 | 23 | |||
| 113979 | 52021 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1001 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2005 12:00:00 AM | 3 | Permit Number 48237 | 6009039.14758 | 2115969.08388 | 37.7905577721826 | -122.412597913578 | (37.7905577721826, -122.412597913578) | 5 | 1 | 10 | 28858 | 21 | ||
| 115497 | 111718 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2390x MASON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008938 | 2121373 | 37.8053899130211 | -122.413330195558 | (37.8053899130211, -122.413330195558) | 3 | 1 | 10 | 308 | 23 | ||||
| 117812 | 136883 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1150 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6007638.793 | 2116445.85143 | 37.7917881670331 | -122.417476873272 | (37.7917881670331, -122.417476873272) | 5 | 1 | 10 | 28858 | 21 | |||
| 118142 | 249817 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1744 Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010847.33897 | 2120972.58058 | 37.8043974733193 | -122.406694407525 | (37.8043974733193, -122.406694407525) | 3 | 1 | 10 | 308 | 23 | |||
| 118895 | 115075 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2371X MASON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008645 | 2121254 | 37.8050467143555 | -122.414335738873 | (37.8050467143555, -122.414335738873) | 3 | 1 | 10 | 308 | 23 | |||
| 119138 | 88405 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1140 Green St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51382 | 6007541.2 | 2118862 | 37.7984168187982 | -122.417985902037 | (37.7984168187982, -122.417985902037) | 5 | 1 | 10 | 28858 | 32 | |||
| 121201 | 142935 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 530 VALLEJO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010961.4694 | 2118993.7222 | 37.7989703977105 | -122.406159945771 | (37.7989703977105, -122.406159945771) | 3 | 1 | 10 | 308 | 23 | |||
| 121837 | 29734 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 644 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2006 12:00:00 AM | 6 | 3x3 | 6009872.4617 | 2119193.0537 | 37.7994567403911 | -122.409942369513 | (37.7994567403911, -122.409942369513) | 3 | 1 | 10 | 308 | 4 | ||
| 122972 | 94461 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1476 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53679 | 6007084.41158 | 2117757.47134 | 37.7953583406805 | -122.419488130584 | (37.7953583406805, -122.419488130584) | 5 | 1 | 10 | 28858 | 32 | |
| 123852 | 136844 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 749 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009177.49317 | 2115540.56084 | 37.7893889152113 | -122.412088946772 | (37.7893889152113, -122.412088946772) | 5 | 1 | 10 | 28858 | 21 | |||
| 124068 | 143021 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 685 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6008591.686 | 2120703.4993 | 37.8035321827214 | -122.414481260898 | (37.8035321827214, -122.414481260898) | 3 | 1 | 10 | 308 | 23 | |||
| 124536 | 110121 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1356 SACRAMENTO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008282.6 | 2116630.5 | 37.7923313700749 | -122.41526237244 | (37.7923313700749, -122.41526237244) | 5 | 1 | 10 | 28858 | 21 | ||||
| 126778 | 136848 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 777 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6008740.77058 | 2115184.4851 | 37.7883867044246 | -122.413574767968 | (37.7883867044246, -122.413574767968) | 5 | 1 | 10 | 28858 | 21 | |||
| 129695 | 116776 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1106 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2016 12:00:00 AM | 3 | 3x3 | 6008776.88904 | 2117992.21481 | 37.7960980717264 | -122.413648471894 | (37.7960980717264, -122.413648471894) | 5 | 1 | 10 | 308 | 21 | ||
| 133052 | 33969 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1997 12:00:00 AM | Permit Number 37917 | 6007661.76235911 | 2121488.31416717 | 37.8056348004683 | -122.417754973992 | (37.8056348004683, -122.417754973992) | 5 | 1 | 10 | 308 | 23 | |||
| 134060 | 142919 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 626 GREEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6009894.6922 | 2119198.6113 | 37.7994732460735 | -122.409865836283 | (37.7994732460735, -122.409865836283) | 3 | 1 | 10 | 308 | 4 | |||
| 136966 | 116777 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1106 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2016 12:00:00 AM | 3 | 3x3 | 6008763.52683 | 2117990.43413 | 37.7960924320727 | -122.413694581941 | (37.7960924320727, -122.413694581941) | 5 | 1 | 10 | 308 | 21 | ||
| 139907 | 102611 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 370 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6010058.3307 | 2120952.6173 | 37.8042984828907 | -122.409423440249 | (37.8042984828907, -122.409423440249) | 3 | 1 | 10 | 308 | 23 | |||
| 141648 | 107633 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 633 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6009218.01318 | 2115223.86517 | 37.78852161892 | -122.411926362828 | (37.78852161892, -122.411926362828) | 5 | 1 | 10 | 28852 | 21 | ||||
| 141678 | 258493 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1100 Montgomery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6011579.56023 | 2119131.56016 | 37.7993834201653 | -122.404030839573 | (37.7993834201653, -122.404030839573) | 3 | 1 | 10 | 308 | 23 | ||||
| 142751 | 143023 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 665 Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6008630.4585 | 2120708.2854 | 37.8035475022359 | -122.414347425317 | (37.8035475022359, -122.414347425317) | 3 | 1 | 10 | 308 | 23 | |||
| 146936 | 114472 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2351 Powell St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009289.50209159 | 2121693.25395674 | 37.8062889786662 | -122.412136419392 | (37.8062889786662, -122.412136419392) | 3 | 1 | 10 | 308 | 23 | ||||
| 149368 | 255519 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1001 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009007.02458 | 2115965.45342 | 37.7905460009358 | -122.41270880089 | (37.7905460009358, -122.41270880089) | 5 | 1 | 10 | 28858 | 21 | ||||
| 150290 | 136913 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 220 Front St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6013055.15483 | 2117019.43362 | 37.7936663561623 | -122.398776419209 | (37.7936663561623, -122.398776419209) | 4 | 1 | 10 | 28860 | 6 | |||
| 150447 | 136906 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 471 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6011241.07834 | 2118988.50847 | 37.7989717177149 | -122.405192033407 | (37.7989717177149, -122.405192033407) | 3 | 1 | 10 | 308 | 23 | |||
| 150454 | 143022 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 675 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6008611.267 | 2120705.7822 | 37.8035395509937 | -122.414413661372 | (37.8035395509937, -122.414413661372) | 3 | 1 | 10 | 308 | 23 | |||
| 152924 | 249319 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1424 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007287 | 2117809 | 37.7955112342357 | -122.41879079594 | (37.7955112342357, -122.41879079594) | 5 | 1 | 10 | 28858 | 32 | ||||
| 152945 | 111717 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2390x MASON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008938 | 2121373 | 37.8053899130211 | -122.413330195558 | (37.8053899130211, -122.413330195558) | 3 | 1 | 10 | 308 | 23 | ||||
| 153996 | 42669 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1374 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2003 12:00:00 AM | 6 | 3x5 | Permit Number 46576 | 6007041.18345 | 2118110.17737 | 37.7963243483505 | -122.419662744764 | (37.7963243483505, -122.419662744764) | 5 | 1 | 10 | 28858 | 32 |
| 159741 | 68423 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1224 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1993 12:00:00 AM | 7 | Permit Number 32271 | 6008889.14366 | 2116691.48815 | 37.7925328983155 | -122.413168024378 | (37.7925328983155, -122.413168024378) | 5 | 1 | 10 | 28857 | 21 | ||
| 161519 | 136882 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1615 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6008349.83625 | 2118003.17581 | 37.7961041781084 | -122.415126940271 | (37.7961041781084, -122.415126940271) | 5 | 1 | 10 | 28858 | 21 | |||
| 162424 | 142646 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2390 Mason St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6008887.4874 | 2121395.0564 | 37.8054476382381 | -122.413506562572 | (37.8054476382381, -122.413506562572) | 3 | 1 | 10 | 308 | 23 | |||
| 163133 | 142484 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 504 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6010505.5827 | 2119623.6166 | 37.8006744234406 | -122.407781912389 | (37.8006744234406, -122.407781912389) | 3 | 1 | 10 | 308 | 23 | |||
| 163320 | 256661 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1306 Broadway | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782593 | 6007370.8774 | 2118134.97157 | 37.7964109931986 | -122.418523691035 | (37.7964109931986, -122.418523691035) | 5 | 1 | 10 | 28858 | 32 | |
| 163799 | 142974 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 370 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010046.6712 | 2120952.6173 | 37.8042978296071 | -122.409463789067 | (37.8042978296071, -122.409463789067) | 3 | 1 | 10 | 308 | 23 | |||
| 169248 | 103272 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 989 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770109 | 6007882.34676 | 2115110.89774 | 37.7881364123041 | -122.416539570166 | (37.7881364123041, -122.416539570166) | 13 | 1 | 10 | 28858 | 21 | |
| 171427 | 116774 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1106 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2016 12:00:00 AM | 3 | 3x3 | 6008811.21548 | 2117995.14613 | 37.7961080479024 | -122.413529902601 | (37.7961080479024, -122.413529902601) | 5 | 1 | 10 | 308 | 21 | ||
| 172996 | 40099 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 657 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/1999 12:00:00 AM | 5 | Permit Number 41324 | 6008068.7482 | 2120981.8075 | 37.8042669554254 | -122.416310639788 | (37.8042669554254, -122.416310639788) | 5 | 1 | 10 | 308 | 32 | ||
| 173133 | 49735 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150@ FRONT California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2003 12:00:00 AM | 5 | Permit Number 46535 | 6013163.90199 | 2116955.46466 | 37.7934967709999 | -122.398395651661 | (37.7934967709999, -122.398395651661) | 4 | 1 | 10 | 28860 | 6 | ||
| 173271 | 136899 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 687 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009739.09157 | 2119126.69971 | 37.7992670730616 | -122.410399191672 | (37.7992670730616, -122.410399191672) | 3 | 1 | 10 | 308 | 4 | |||
| 176088 | 50415 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 801@Jones Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49829 | 6008741.29030404 | 2115233.52587173 | 37.7885213876682 | -122.41357643968 | (37.7885213876682, -122.41357643968) | 5 | 1 | 10 | 28858 | 21 | ||
| 182246 | 136847 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 777 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6008735.20031 | 2115208.76396 | 37.7884530555027 | -122.413595758142 | (37.7884530555027, -122.413595758142) | 5 | 1 | 10 | 28858 | 21 | |||
| 182436 | 81955 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 611 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769820 | 6007855.44707 | 2114525.76185 | 37.7865282590267 | -122.416591172348 | (37.7865282590267, -122.416591172348) | 13 | 1 | 9 | 28858 | 36 |
| 183626 | 142645 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2380 Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008890.0639 | 2121379.5977 | 37.805405337199 | -122.41349655223 | (37.805405337199, -122.41349655223) | 3 | 1 | 10 | 308 | 23 | |||||
| 184869 | 115076 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2371X MASON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6008645 | 2121254 | 37.8050467143555 | -122.414335738873 | (37.8050467143555, -122.414335738873) | 3 | 1 | 10 | 308 | 23 | |||
| 186384 | 142644 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2370 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6008891.6098 | 2121361.5625 | 37.8053559038697 | -122.413489926105 | (37.8053559038697, -122.413489926105) | 3 | 1 | 10 | 308 | 23 | |||
| 187987 | 136911 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 220 Front St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6013060.50626 | 2116980.18052 | 37.7935588745932 | -122.39875514664 | (37.7935588745932, -122.39875514664) | 4 | 1 | 10 | 28860 | 6 | |||
| 188825 | 102612 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 376 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010060 | 2120948 | 37.8042858984606 | -122.409417337419 | (37.8042858984606, -122.409417337419) | 3 | 1 | 10 | 308 | 23 | ||||
| 189683 | 93480 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1356- 1360 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2014 12:00:00 AM | 12 | 3x2 | Permit Number 770976 | 6008293.46712 | 2116608.96674 | 37.7922728557673 | -122.415223246858 | (37.7922728557673, -122.415223246858) | 5 | 1 | 10 | 28858 | 21 | |
| 190292 | 116775 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1106 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2016 12:00:00 AM | 3 | 3x3 | 6008794.04431 | 2117993.28546 | 37.7961019747828 | -122.413589186808 | (37.7961019747828, -122.413589186808) | 5 | 1 | 10 | 308 | 21 | ||
| 190944 | 143054 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1731 Grant Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010429.028 | 2120490.458 | 37.8030502706615 | -122.408107992666 | (37.8030502706615, -122.408107992666) | 3 | 1 | 10 | 308 | 23 | |||
| 2643 | 112356 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 333 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6009373.44227 | 2114078.66133 | 37.7853858834919 | -122.411307667026 | (37.7853858834919, -122.411307667026) | 14 | 10 | 9 | 28852 | 36 | |||
| 32851 | 136853 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 628 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 782762 | 6008257.35293 | 2114172.86388 | 37.7855818817524 | -122.415175683534 | (37.7855818817524, -122.415175683534) | 13 | 10 | 9 | 28858 | 36 |
| 40948 | 51847 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 138 Cyril Magnin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 3x3 | Permit Number 48071 | 6010188.39401853 | 2113860.37409529 | 37.7848321915742 | -122.408472762748 | (37.7848321915742, -122.408472762748) | 14 | 10 | 10 | 28852 | 36 | ||
| 65375 | 46592 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 255 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51875 | 6008348.96688497 | 2112748.91924615 | 37.7816772210699 | -122.414757915305 | (37.7816772210699, -122.414757915305) | 7 | 10 | 9 | 28852 | 36 | |
| 79685 | 51846 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 138 Cyril Magnin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2017 12:00:00 AM | 3 | Permit Number 48071 | 6010119.81915 | 2114194.4742 | 37.785745710337 | -122.40873358881 | (37.785745710337, -122.40873358881) | 14 | 10 | 10 | 28852 | 36 | ||
| 79789 | 83785 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 144 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2008 12:00:00 AM | 3x3 | Permit Number 51882 | 6008612.48195203 | 2112968.71572945 | 37.7822955319647 | -122.413861827361 | (37.7822955319647, -122.413861827361) | 7 | 10 | 9 | 28852 | 36 | ||
| 104516 | 114310 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 555 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008134.5912 | 2113761.57419 | 37.7844456800549 | -122.415571274614 | (37.7844456800549, -122.415571274614) | 7 | 10 | 9 | 28858 | 36 | |||
| 108494 | 51845 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 138 Cyril Magnin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2017 12:00:00 AM | 3 | Permit Number 48071 | 6010129.68999 | 2114173.2637 | 37.7856880242154 | -122.408697941478 | (37.7856880242154, -122.408697941478) | 14 | 10 | 10 | 28852 | 36 | ||
| 110403 | 114314 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 555 Ellis St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008206.99972 | 2113769.08598 | 37.7844703754417 | -122.415321297236 | (37.7844703754417, -122.415321297236) | 7 | 10 | 9 | 28858 | 36 | |||
| 117413 | 114312 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 555 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6008176.56579 | 2113766.43822 | 37.7844613948136 | -122.415426401003 | (37.7844613948136, -122.415426401003) | 7 | 10 | 9 | 28858 | 36 | |||
| 118241 | 114313 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 555 Ellis St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6008193.82631 | 2113767.31151 | 37.7844647627846 | -122.415366747192 | (37.7844647627846, -122.415366747192) | 7 | 10 | 9 | 28858 | 36 | |||
| 122437 | 112355 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 333 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6009378.26981 | 2114060.90388 | 37.7853373965427 | -122.411289710245 | (37.7853373965427, -122.411289710245) | 14 | 10 | 9 | 28852 | 36 | |||
| 134241 | 51844 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 138 Cyril Magnin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2017 12:00:00 AM | 3 | Permit Number 48071 | 6010139.87184 | 2114143.25233 | 37.7856061904094 | -122.408660597109 | (37.7856061904094, -122.408660597109) | 14 | 10 | 10 | 28852 | 36 | ||
| 143509 | 114311 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 555 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008160.91319 | 2113763.897 | 37.7844535374571 | -122.415480373815 | (37.7844535374571, -122.415480373815) | 7 | 10 | 9 | 28858 | 36 | |||
| 148423 | 43086 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 240 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | 3 | Permit Number 768443 | 6009026.56135 | 2113486.19623 | 37.7837396556058 | -122.412465881408 | (37.7837396556058, -122.412465881408) | 14 | 10 | 9 | 28852 | 36 | |
| 171284 | 112358 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 333 TAYLOR ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009361 | 2114091 | 37.7854190646881 | -122.411351585686 | (37.7854190646881, -122.411351585686) | 14 | 10 | 9 | 28852 | 36 | ||||
| 173706 | 112357 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 333 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6009370.03469 | 2114102.41995 | 37.785450927851 | -122.411321135269 | (37.785450927851, -122.411321135269) | 14 | 10 | 9 | 28852 | 36 | |||
| 188475 | 68244 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 555 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/1993 12:00:00 AM | 5 | 3x3 | Permit Number 32044 | 6008117.28048 | 2113758.24909 | 37.7844355770813 | -122.41563092842 | (37.7844355770813, -122.41563092842) | 7 | 10 | 9 | 28858 | 36 | |
| 616 | 243196 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1330 Stevenson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6006254.26009 | 2108909.80844 | 37.771018033881 | -122.421731852741 | (37.771018033881, -122.421731852741) | 8 | 2 | 9 | 28853 | 19 | |||
| 1041 | 109054 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 200 Shipley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011721.75389 | 2111961.27607 | 37.7797034631784 | -122.403034183007 | (37.7797034631784, -122.403034183007) | 14 | 2 | 9 | 28856 | 34 | |||
| 1229 | 264907 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 1391 | 71539 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 277 Shipley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6011318.23655 | 2111544.70179 | 37.7785371054488 | -122.40440080265 | (37.7785371054488, -122.40440080265) | 14 | 2 | 9 | 28856 | 34 | |||
| 1478 | 242990 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1330 Stevenson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x2.5 | 6006256.26412 | 2108953.61059 | 37.7711384171253 | -122.421728032423 | (37.7711384171253, -122.421728032423) | 8 | 2 | 9 | 28853 | 19 | |||
| 1580 | 31821 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 195 07th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 4 | Permit Number 35284 | 6009820.27489 | 2111475.42861 | 37.7782630739317 | -122.409577954154 | (37.7782630739317, -122.409577954154) | 14 | 2 | 9 | 28853 | 34 | |
| 2227 | 28919 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 230 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2006 12:00:00 AM | 3 | 3x3 | 6009994.1526974 | 2111207.6693813 | 37.7775376115192 | -122.408957547154 | (37.7775376115192, -122.408957547154) | 8 | 2 | 9 | 28853 | 34 | ||
| 2622 | 65282 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 445 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/1989 12:00:00 AM | 1 | Permit Number 28089 | 6011007.15755 | 2112137.38618 | 37.7801470897487 | -122.405518702235 | (37.7801470897487, -122.405518702235) | 14 | 2 | 9 | 28853 | 34 | |
| 2913 | 264905 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 4232 | 264908 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 259 Clara St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011556 | 2111491 | 37.778402936715 | -122.403574504421 | (37.778402936715, -122.403574504421) | 14 | 2 | 9 | 28856 | 34 | ||||
| 5210 | 240637 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 3x3 | 6005372.47745 | 2108674.6931 | 37.7703226996495 | -122.424765239935 | (37.7703226996495, -122.424765239935) | 8 | 2 | 5 | 28853 | 19 | ||
| 5465 | 198179 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 227 07th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010077.86899 | 2111204.28564 | 37.7775330096684 | -122.408667704448 | (37.7775330096684, -122.408667704448) | 14 | 2 | 9 | 28853 | 34 |
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) );