trees
331 rows where qSpecies_id = 166 sorted by rowid descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194223 | 14733 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 912X Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004848.1679 | 2112085.98552 | 37.7796596496687 | -122.426821804086 | (37.7796596496687, -122.426821804086) | 7 | 9 | 11 | 28852 | 41 | |||
| 193276 | 103200 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1601X 28th Ave | 21 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||
| 191812 | 178116 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988774.08393 | 2089765.94009 | 37.7174527715132 | -122.480793855056 | (37.7174527715132, -122.480793855056) | 1 | 8 | 4 | 64 | 14 | ||||
| 189840 | 35868 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1 Boutwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | Permit Number 39080 | 6010677.15913478 | 2096883.63230355 | 37.7382452410033 | -122.405585668988 | (37.7382452410033, -122.405585668988) | 10 | 3 | 8 | 58 | 1 | ||
| 188193 | 178120 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 450 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6007489.47996 | 2091618.13072 | 37.7236085535687 | -122.416234291698 | (37.7236085535687, -122.416234291698) | 9 | 3 | 7 | 309 | 28 | |||
| 187426 | 21368 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2592X Sunset Blvd | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | 1 | 8 | 3 | 29491 | 35 | |||
| 185781 | 37765 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 757 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/1998 12:00:00 AM | Permit Number 40107 | 6009292.34813985 | 2092404.74391338 | 37.7258696386057 | -122.41005757271 | (37.7258696386057, -122.41005757271) | 9 | 3 | 7 | 309 | 28 | ||
| 185669 | 141416 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 500 Ivy St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005151 | 2111194 | 37.7772275935342 | -122.425710670776 | (37.7772275935342, -122.425710670776) | 7 | 9 | 11 | 28852 | 10 | |||
| 185539 | 178102 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 450 Holyoke St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009843.47083 | 2092285.37144 | 37.7255727412698 | -122.408143956404 | (37.7255727412698, -122.408143956404) | 10 | 3 | 7 | 309 | 28 | |||
| 184467 | 178119 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 463 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007549.64537 | 2091584.69252 | 37.7235201223396 | -122.416023942951 | (37.7235201223396, -122.416023942951) | 9 | 3 | 7 | 309 | 28 | |||
| 183907 | 234444 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 916 Elizabeth St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 3ft | 6000579.9862 | 2102015.32983 | 37.7517658799102 | -122.440864630698 | (37.7517658799102, -122.440864630698) | 2 | 4 | 5 | 28862 | 22 | |||
| 182666 | 132140 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 3500 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000293.03913 | 2120313.27667 | 37.8019910386216 | -122.443170972674 | (37.8019910386216, -122.443170972674) | 13 | 9 | 1 | 57 | 17 | |||
| 182385 | 182438 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1551 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5989915.2502 | 2104791.6969 | 37.758775892484 | -122.477947270142 | (37.758775892484, -122.477947270142) | 1 | 8 | 3 | 56 | 35 | |||
| 182342 | 139016 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2569 SUTTER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6000276.5862 | 2114052.7703 | 37.7848003959002 | -122.442778104076 | (37.7848003959002, -122.442778104076) | 15 | 6 | 11 | 29490 | 13 | |||
| 181589 | 73314 | Private 9 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1142 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/2014 12:00:00 AM | 3 | 3x3 | 6009184.98526399 | 2102501.75487234 | 37.7535878144828 | -122.411141625253 | (37.7535878144828, -122.411141625253) | 2 | 4 | 7 | 28859 | 19 | ||
| 181481 | 139023 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2511 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6000454.7447 | 2114081.9995 | 37.7848908066545 | -122.442163834685 | (37.7848908066545, -122.442163834685) | 15 | 6 | 11 | 29490 | 13 | |||
| 181339 | 183792 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2018 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5986653.8717 | 2099631.7621 | 37.7444182780506 | -122.488847170158 | (37.7444182780506, -122.488847170158) | 1 | 8 | 3 | 29491 | 35 | |||
| 181209 | 210948 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 466 Ralston St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 5992243.02346 | 2090933.92849 | 37.7208608027661 | -122.468888386993 | (37.7208608027661, -122.468888386993) | 9 | 8 | 6 | 64 | 24 | |||
| 180498 | 210945 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 78 Lobos St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5996140.80305 | 2088701.93983 | 37.7149567103495 | -122.455253805936 | (37.7149567103495, -122.455253805936) | 9 | 8 | 6 | 28861 | 24 | ||||
| 180369 | 210960 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1200 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992416.63025 | 2098463.8741 | 37.7415461874123 | -122.468835952941 | (37.7415461874123, -122.468835952941) | 1 | 8 | 4 | 29491 | 40 | |||
| 180357 | 15063 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1X Minerva St | 6 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5995983.74533 | 2089004.6361 | 37.7157788310068 | -122.455818528899 | (37.7157788310068, -122.455818528899) | 9 | 8 | 6 | 28861 | 24 | |||
| 180312 | 141410 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 500 Ivy St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005151 | 2111194 | 37.7772275935342 | -122.425710670776 | (37.7772275935342, -122.425710670776) | 7 | 9 | 11 | 28852 | 10 | |||
| 178994 | 194409 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 538 Mississippi St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6014067.65715 | 2104573.47269 | 37.7595489177536 | -122.394401194978 | (37.7595489177536, -122.394401194978) | 10 | 3 | 8 | 28856 | 29 | |||
| 178247 | 178124 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 7 Still St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6003171.4318 | 2094651.692 | 37.7316942816694 | -122.431377466599 | (37.7316942816694, -122.431377466599) | 9 | 7 | 5 | 28861 | 25 | |||
| 178215 | 132145 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 540 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6004877.00023 | 2111089.96239 | 37.7769264448274 | -122.426651113773 | (37.7769264448274, -122.426651113773) | 7 | 9 | 11 | 28852 | 10 | |||
| 177833 | 31861 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 603 Natoma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42495 | 6009703.09193941 | 2111483.74896598 | 37.7782793527016 | -122.409983922333 | (37.7782793527016, -122.409983922333) | 8 | 2 | 9 | 28853 | 34 | ||
| 177383 | 66146 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1870 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1990 12:00:00 AM | 7 | Permit Number 29213 | 6000296.96947 | 2121326.31343 | 37.8047727901033 | -122.443230173234 | (37.8047727901033, -122.443230173234) | 13 | 9 | 1 | 57 | 17 | ||
| 176973 | 101292 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1573 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6006005.37071 | 2118256.53367 | 37.7966678039418 | -122.423257287321 | (37.7966678039418, -122.423257287321) | 13 | 9 | 10 | 28858 | 32 | |||
| 176118 | 103232 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1600X 29th Ave | 23 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 176040 | 103192 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1601X 28th Ave | 9 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 0 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | |||
| 175266 | 14739 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 890X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/15/2002 12:00:00 AM | 3 | 4X4 | 6004895.58164 | 2111744.14099 | 37.7787237093276 | -122.426633429967 | (37.7787237093276, -122.426633429967) | 7 | 9 | 11 | 28852 | 41 | ||
| 174865 | 210969 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1901 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991556.95578 | 2102433.12062 | 37.7523950096285 | -122.472097634809 | (37.7523950096285, -122.472097634809) | 1 | 8 | 4 | 29491 | 12 | |||
| 174713 | 17948 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2475 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6002031.27574 | 2114994.27895 | 37.787485413843 | -122.436774883786 | (37.787485413843, -122.436774883786) | 13 | 6 | 11 | 29490 | 27 | |||
| 173756 | 210949 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 521 Victoria St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5993238.50439 | 2090644.65607 | 37.7201239945015 | -122.465426336151 | (37.7201239945015, -122.465426336151) | 9 | 8 | 6 | 64 | 24 | |||
| 173399 | 62425 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2190 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/1990 12:00:00 AM | 7 | Permit Number 28803 | 6000367.76926 | 2120295.99012 | 37.8019478351817 | -122.442911129744 | (37.8019478351817, -122.442911129744) | 13 | 9 | 1 | 57 | 17 | |
| 173257 | 132144 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 525 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6004910.26431 | 2111067.91228 | 37.7768677811601 | -122.426534472605 | (37.7768677811601, -122.426534472605) | 7 | 9 | 11 | 28852 | 10 | |||
| 171529 | 210947 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 171 Ralston St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5992177.81487 | 2089015.33856 | 37.715589054271 | -122.468974238973 | (37.715589054271, -122.468974238973) | 9 | 8 | 6 | 64 | 24 | |||
| 171363 | 210983 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1 Pizarro Way | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5995109.5477 | 2093940.82362 | 37.7292822109006 | -122.459197374461 | (37.7292822109006, -122.459197374461) | 9 | 7 | 4 | 28861 | 40 | |||
| 170926 | 234457 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 6 Park Hill Ave | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 6001153.42663 | 2107602.71165 | 37.7671401095592 | -122.439282048744 | (37.7671401095592, -122.439282048744) | 15 | 5 | 5 | 29492 | 3 | |||
| 170552 | 194414 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2190 Revere Ave | 1 | Front Yard : Yard | Tree | Private 2 | 9 | 6011991.11483 | 2096738.36261 | 37.7379197467887 | -122.401032427923 | (37.7379197467887, -122.401032427923) | 10 | 3 | 8 | 58 | 1 | ||||
| 169609 | 178113 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 557 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009795.00603 | 2092562.31425 | 37.7263304542784 | -122.408331020778 | (37.7263304542784, -122.408331020778) | 10 | 3 | 7 | 309 | 28 | |||
| 169597 | 210976 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 260 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5993323.42332 | 2099719.9683 | 37.7450474513929 | -122.465791839533 | (37.7450474513929, -122.465791839533) | 1 | 8 | 4 | 29491 | 40 | |||
| 169467 | 31857 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 603 Natoma St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42495 | 6009703.09193941 | 2111483.74896598 | 37.7782793527016 | -122.409983922333 | (37.7782793527016, -122.409983922333) | 8 | 2 | 9 | 28853 | 34 | ||
| 169284 | 141415 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 530 IVY ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004662.5142 | 2111058.1591 | 37.7768269924265 | -122.427390820691 | (37.7768269924265, -122.427390820691) | 7 | 9 | 11 | 28852 | 10 | |||
| 168042 | 234451 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1100 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009637.31299 | 2098000.1407 | 37.7412527305218 | -122.40925972546 | (37.7412527305218, -122.40925972546) | 10 | 7 | 7 | 28859 | 2 | |||
| 167586 | 178118 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988803.05395 | 2089760.98409 | 37.7174408474004 | -122.480693357611 | (37.7174408474004, -122.480693357611) | 1 | 8 | 4 | 64 | 14 | ||||
| 167433 | 181924 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2347 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5985449.2316 | 2099241.7124 | 37.7432769299175 | -122.49298378014 | (37.7432769299175, -122.49298378014) | 1 | 8 | 3 | 29491 | 35 | |||
| 167202 | 43262 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 449 Holyoke St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | Permit Number 43044 | 6009825.48813974 | 2092359.64445753 | 37.7257756724777 | -122.408211357365 | (37.7257756724777, -122.408211357365) | 10 | 3 | 7 | 309 | 28 | ||
| 167137 | 141405 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 500 IVY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/1995 12:00:00 AM | 3 | Width 0ft | Permit Number 34950 | 6004899.5578 | 2111091.1041 | 37.7769308549567 | -122.426573161514 | (37.7769308549567, -122.426573161514) | 7 | 9 | 11 | 28852 | 10 | |
| 166519 | 37797 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 407 Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | 1 | Permit Number 40124 | 6010065.36404 | 2092583.86022 | 37.7264047508705 | -122.407397920192 | (37.7264047508705, -122.407397920192) | 10 | 3 | 7 | 309 | 28 | |
| 166000 | 234437 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 197 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6004769.01053 | 2102546.09343 | 37.7534609185083 | -122.426416200065 | (37.7534609185083, -122.426416200065) | 2 | 4 | 5 | 28862 | 22 | |||
| 165657 | 27311 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2660 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2000 12:00:00 AM | 4 | 1x1 | 6011096.5026246 | 2093175.2702825 | 37.7280862997813 | -122.403874899606 | (37.7280862997813, -122.403874899606) | 10 | 3 | 7 | 309 | 28 | ||
| 165130 | 234450 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1100 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009611.48566 | 2098000.00839 | 37.7412509202074 | -122.409349018258 | (37.7412509202074, -122.409349018258) | 10 | 7 | 7 | 28859 | 2 | |||
| 162920 | 234465 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 90 Divisadero St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6001962.28164 | 2108178.26403 | 37.7687664300461 | -122.436525544813 | (37.7687664300461, -122.436525544813) | 15 | 5 | 5 | 29492 | 3 | |||
| 161668 | 132157 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2712 Steiner St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 4ft | 6002161.41755 | 2117456.24016 | 37.7942527204522 | -122.436500900709 | (37.7942527204522, -122.436500900709) | 13 | 9 | 1 | 29490 | 27 | |||
| 161644 | 37769 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 757 Bacon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/1998 12:00:00 AM | Permit Number 40107 | 6009292.34813985 | 2092404.74391338 | 37.7258696386057 | -122.41005757271 | (37.7258696386057, -122.41005757271) | 9 | 3 | 7 | 309 | 28 | ||
| 158776 | 254564 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 890X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/15/2002 12:00:00 AM | 3X3 | 6004895.58164 | 2111744.14099 | 37.7787237093276 | -122.426633429967 | (37.7787237093276, -122.426633429967) | 7 | 9 | 11 | 28852 | 41 | |||
| 158429 | 40754 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 128 Corona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/13/1999 12:00:00 AM | Permit Number 41724 | 5993008.60966906 | 2092048.1240652 | 37.723964314455 | -122.46632294355 | (37.723964314455, -122.46632294355) | 9 | 8 | 4 | 59 | 40 | ||
| 156456 | 183793 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2020 Santiago St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5986629.5476 | 2099631.7621 | 37.7444168584558 | -122.488931276724 | (37.7444168584558, -122.488931276724) | 1 | 8 | 3 | 29491 | 35 | |||
| 156127 | 234463 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 4089 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002451.16562 | 2104701.74452 | 37.7592485226079 | -122.43458591763 | (37.7592485226079, -122.43458591763) | 2 | 4 | 5 | 28862 | 3 | |||
| 154993 | 45308 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 73 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2001 12:00:00 AM | Permit Number 44146 | 5994124.56129727 | 2090407.79680159 | 37.7195246979994 | -122.462346388785 | (37.7195246979994, -122.462346388785) | 9 | 8 | 6 | 28861 | 24 | ||
| 154827 | 210938 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 140 Jules Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5994485.61815 | 2090821.98023 | 37.7206827307129 | -122.461128361887 | (37.7206827307129, -122.461128361887) | 9 | 8 | 6 | 28861 | 24 | |||
| 154457 | 43359 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 4140 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43110 | 6002236.76771757 | 2102396.97114609 | 37.7529079947567 | -122.435162559192 | (37.7529079947567, -122.435162559192) | 2 | 4 | 5 | 28862 | 22 | ||
| 154020 | 103195 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1601X 28th Ave | 14 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
| 153357 | 132148 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 540 Ivy St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6004787.54086 | 2111075.34441 | 37.7768812494174 | -122.426959539871 | (37.7768812494174, -122.426959539871) | 7 | 9 | 11 | 28852 | 10 | |||
| 153119 | 132143 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 525 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6004895.04277 | 2111066.14782 | 37.7768620758709 | -122.426587002881 | (37.7768620758709, -122.426587002881) | 7 | 9 | 11 | 28852 | 10 | |||
| 152702 | 68362 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 536 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/29/1993 12:00:00 AM | 4 | Permit Number 32183 | 6009840.43675 | 2092622.33967 | 37.7264978154083 | -122.408178199862 | (37.7264978154083, -122.408178199862) | 10 | 3 | 7 | 309 | 28 | |
| 152610 | 183459 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2530 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5989571.117 | 2098107.4281 | 37.7404026737429 | -122.47864859712 | (37.7404026737429, -122.47864859712) | 1 | 8 | 3 | 29491 | 35 | |||
| 152534 | 234435 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2872 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010145.61558 | 2101660.41688 | 37.7513315127422 | -122.407760219263 | (37.7513315127422, -122.407760219263) | 2 | 4 | 7 | 28859 | 19 | |||
| 151598 | 186337 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1801 Sunset Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984807.2585 | 2102868.5467 | 37.7531976608065 | -122.495470957814 | (37.7531976608065, -122.495470957814) | 1 | 8 | 3 | 56 | 35 | |||
| 151226 | 53043 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 331@ ALABAMA Rutledge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2006 12:00:00 AM | Permit Number 49021 | 6009634.4560959 | 2099333.48730709 | 37.7449136491377 | -122.40936367722 | (37.7449136491377, -122.40936367722) | 2 | 7 | 7 | 28859 | 2 | |||
| 151116 | 96615 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1224 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767286 | 6008996.31071 | 2117161.4041 | 37.7938291883275 | -122.412830459354 | (37.7938291883275, -122.412830459354) | 3 | 1 | 10 | 28857 | 21 | |
| 151078 | 21366 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2592X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | 1 | 8 | 3 | 29491 | 35 | |||
| 150805 | 210971 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1901 15th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5991557.23567 | 2102412.45554 | 37.752338284906 | -122.472095160778 | (37.752338284906, -122.472095160778) | 1 | 8 | 4 | 29491 | 12 | |||
| 150752 | 140013 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 840 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004880.8164 | 2111850.7611 | 37.7790156271835 | -122.426692103329 | (37.7790156271835, -122.426692103329) | 7 | 9 | 11 | 28852 | 41 | |||
| 150588 | 141414 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 500 Ivy St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005151 | 2111194 | 37.7772275935342 | -122.425710670776 | (37.7772275935342, -122.425710670776) | 7 | 9 | 11 | 28852 | 10 | |||
| 150161 | 3779 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 7 Carpenter Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/1997 12:00:00 AM | 5 | 3X3 | 6016553.62516 | 2095504.97734 | 37.7347865780402 | -122.385171527445 | (37.7347865780402, -122.385171527445) | 10 | 3 | 8 | 58 | 1 | ||
| 149154 | 234445 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 540 28th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 6002416.20588 | 2099477.11342 | 37.7449009428194 | -122.434333293569 | (37.7449009428194, -122.434333293569) | 2 | 7 | 5 | 63 | 22 | |||
| 148590 | 234466 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 709 Duboce Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6002112.19122 | 2108241.56843 | 37.7689487658049 | -122.436011549895 | (37.7689487658049, -122.436011549895) | 15 | 5 | 5 | 29492 | 3 | |||
| 148425 | 218109 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 55 Lopez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5993991.90268 | 2100564.68754 | 37.7474053748569 | -122.463541667417 | (37.7474053748569, -122.463541667417) | 1 | 8 | 4 | 29491 | 40 | |||
| 148160 | 210967 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 375 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1993 12:00:00 AM | 4 | Width 3ft | Permit Number 32251 | 5992728.19812 | 2094135.00675 | 37.7296781967805 | -122.467443955276 | (37.7296781967805, -122.467443955276) | 9 | 8 | 4 | 59 | 40 | |
| 147680 | 132151 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 540 Ivy St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004697.15203 | 2111064.23767 | 37.7768456416404 | -122.427271431055 | (37.7768456416404, -122.427271431055) | 7 | 9 | 11 | 28852 | 10 | |||
| 145153 | 139013 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2569 SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6000229.2629 | 2114047.2029 | 37.7847824113212 | -122.442941426751 | (37.7847824113212, -122.442941426751) | 15 | 6 | 11 | 29490 | 13 | |||
| 144810 | 183458 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2530 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5989571.117 | 2098094.1306 | 37.7403661622566 | -122.478647624894 | (37.7403661622566, -122.478647624894) | 1 | 8 | 3 | 29491 | 35 | |||
| 143715 | 210952 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 82 Vernon St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5992474.65853 | 2088476.64416 | 37.7141270758919 | -122.467909063055 | (37.7141270758919, -122.467909063055) | 9 | 8 | 6 | 64 | 24 | |||
| 143268 | 119909 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2x Lucy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6014143.19985 | 2094023.91332 | 37.7305862422565 | -122.393401649772 | (37.7305862422565, -122.393401649772) | 10 | 3 | 8 | 58 | 1 | |||
| 141875 | 218108 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 65 Lopez Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5993986.53674 | 2100544.36079 | 37.7473492535732 | -122.463558747362 | (37.7473492535732, -122.463558747362) | 1 | 8 | 4 | 29491 | 40 | |||
| 141478 | 37768 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 757 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/1998 12:00:00 AM | Permit Number 40107 | 6009292.34813985 | 2092404.74391338 | 37.7258696386057 | -122.41005757271 | (37.7258696386057, -122.41005757271) | 9 | 3 | 7 | 309 | 28 | ||
| 141261 | 11330 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1239 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/1999 12:00:00 AM | 80 | 3X3 | 6017503.8498875 | 2093941.8686813 | 37.7305471093878 | -122.381777557673 | (37.7305471093878, -122.381777557673) | 10 | 3 | 8 | 58 | 1 | ||
| 140894 | 178107 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 409 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009776.35122 | 2092502.75191 | 37.7261658639547 | -122.408391310431 | (37.7261658639547, -122.408391310431) | 10 | 3 | 7 | 309 | 28 | |||
| 140740 | 210943 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 901 Plymouth Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995890.03888 | 2089972.39061 | 37.718430679009 | -122.456212350133 | (37.718430679009, -122.456212350133) | 9 | 8 | 6 | 28861 | 24 | |||
| 140701 | 210935 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 147 Chaves Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5996689.45961 | 2098368.41594 | 37.7415300122068 | -122.454055155315 | (37.7415300122068, -122.454055155315) | 9 | 7 | 4 | 59 | 40 | |||
| 140541 | 132155 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 540 Ivy St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004627.84301 | 2111055.1905 | 37.7768168804195 | -122.427510547282 | (37.7768168804195, -122.427510547282) | 7 | 9 | 11 | 28852 | 10 | |||
| 140129 | 234434 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1256 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010030.06778 | 2101895.59266 | 37.7519707841232 | -122.408176383232 | (37.7519707841232, -122.408176383232) | 2 | 4 | 7 | 28859 | 19 | |||
| 138735 | 139021 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2557 SUTTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6000404.6376 | 2114075.0402 | 37.7848688424651 | -122.442336688766 | (37.7848688424651, -122.442336688766) | 15 | 6 | 11 | 29490 | 13 | |||
| 138713 | 234446 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 500x 27th St | 15 | Median : Cutout | Tree | DPW 1 | 5 | Width 4ft | 6002865.64838 | 2100065.87647 | 37.7465430491228 | -122.43282125802 | (37.7465430491228, -122.43282125802) | 2 | 7 | 5 | 63 | 22 | |||
| 138170 | 89380 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1250X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/06/2008 12:00:00 AM | 3 | 3x3 | 5994772.91396 | 2112159.37755 | 37.7792863553313 | -122.461681542526 | (37.7792863553313, -122.461681542526) | 11 | 6 | 2 | 54 | 11 | ||
| 136717 | 234428 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 2644 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010244.9423 | 2104006.47473 | 37.7577788253492 | -122.407582127418 | (37.7577788253492, -122.407582127418) | 10 | 4 | 7 | 28859 | 19 | |||
| 136418 | 56794 | Permitted Site 7 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1303 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/30/1974 12:00:00 AM | 3x3 | Permit Number 14019 | 6000327.28850998 | 2109204.10022929 | 37.7714900745599 | -122.4422544996 | (37.7714900745599, -122.4422544996) | 15 | 5 | 11 | 29492 | 9 | ||
| 135766 | 234456 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 148 Saturn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5999835.14903 | 2106019.07755 | 37.7627167392014 | -122.44372797587 | (37.7627167392014, -122.44372797587) | 15 | 5 | 5 | 28862 | 3 |
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) );