trees
7,157 rows where qSpecies_id = 36 sorted by Longitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 70962 | 195002 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 11 Dedman Ct | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6016680.46739 | 2096324.02955 | 37.737042547164 | -122.384790025147 | (37.737042547164, -122.384790025147) | 10 | 3 | 8 | 58 | 1 | |||
| 38414 | 4947 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 56 Dedman Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/16/2013 12:00:00 AM | 3 | 3X4 | 6016676.7719828 | 2096248.5036614 | 37.7368349638651 | -122.384797542111 | (37.7368349638651, -122.384797542111) | 10 | 3 | 8 | 58 | 1 | ||
| 17159 | 3838 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 55X Dedman Ct | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/16/2013 12:00:00 AM | 3 | 3X4 | 6016670.3231407 | 2096336.3389693 | 37.7370757852971 | -122.38482595599 | (37.7370757852971, -122.38482595599) | 10 | 3 | 8 | 58 | 1 | ||
| 27890 | 3833 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 55X Dedman Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016670.3231407 | 2096336.3389693 | 37.7370757852971 | -122.38482595599 | (37.7370757852971, -122.38482595599) | 10 | 3 | 8 | 58 | 1 | |||
| 49065 | 3836 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 55X Dedman Ct | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016670.3231407 | 2096336.3389693 | 37.7370757852971 | -122.38482595599 | (37.7370757852971, -122.38482595599) | 10 | 3 | 8 | 58 | 1 | |||
| 92443 | 3835 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 55X Dedman Ct | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016670.3231407 | 2096336.3389693 | 37.7370757852971 | -122.38482595599 | (37.7370757852971, -122.38482595599) | 10 | 3 | 8 | 58 | 1 | |||
| 123294 | 3834 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 55X Dedman Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016670.3231407 | 2096336.3389693 | 37.7370757852971 | -122.38482595599 | (37.7370757852971, -122.38482595599) | 10 | 3 | 8 | 58 | 1 | |||
| 181738 | 3837 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 55X Dedman Ct | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016670.3231407 | 2096336.3389693 | 37.7370757852971 | -122.38482595599 | (37.7370757852971, -122.38482595599) | 10 | 3 | 8 | 58 | 1 | |||
| 106964 | 194993 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 11 Dedman Ct | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6016666.91798 | 2096257.09731 | 37.7368580152904 | -122.384832210557 | (37.7368580152904, -122.384832210557) | 10 | 3 | 8 | 58 | 1 | |||
| 191862 | 195003 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 11 Dedman Ct | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6016650.36466 | 2096329.60482 | 37.7370561907825 | -122.384894493113 | (37.7370561907825, -122.384894493113) | 10 | 3 | 8 | 58 | 1 | |||
| 6501 | 194992 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 11 Dedman Ct | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6016636.86174 | 2096261.76833 | 37.7368691785546 | -122.384936454554 | (37.7368691785546, -122.384936454554) | 10 | 3 | 8 | 58 | 1 | |||
| 28794 | 4943 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 47 Dedman Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016624.9255784 | 2096337.2776573 | 37.7370758517684 | -122.384982982724 | (37.7370758517684, -122.384982982724) | 10 | 3 | 8 | 58 | 1 | |||
| 108713 | 4941 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 45 Dedman Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016613.8530023 | 2096337.5066056 | 37.7370758679492 | -122.385021281927 | (37.7370758679492, -122.385021281927) | 10 | 3 | 8 | 58 | 1 | |||
| 143025 | 4940 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 41 Dedman Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016582.9865799 | 2096332.2845671 | 37.7370598218803 | -122.385127638349 | (37.7370598218803, -122.385127638349) | 10 | 3 | 8 | 58 | 1 | |||
| 29958 | 4939 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 36 Dedman Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/16/2013 12:00:00 AM | 3 | 3X4 | 6016579.870147 | 2096241.2722059 | 37.7368097478482 | -122.385132073872 | (37.7368097478482, -122.385132073872) | 10 | 3 | 8 | 58 | 1 | ||
| 10781 | 194991 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 11 Dedman Ct | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6016579.94443 | 2096258.22378 | 37.7368562975712 | -122.385132997804 | (37.7368562975712, -122.385132997804) | 10 | 3 | 8 | 58 | 1 | |||
| 38790 | 4938 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 32 Dedman Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/16/2013 12:00:00 AM | 3 | 3X4 | 6016560.079734 | 2096235.7096036 | 37.7367933792846 | -122.385200111187 | (37.7367933792846, -122.385200111187) | 10 | 3 | 8 | 58 | 1 | ||
| 175034 | 194990 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 11 Dedman Ct | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6016555.9151 | 2096250.2636 | 37.7368331112452 | -122.385215524091 | (37.7368331112452, -122.385215524091) | 10 | 3 | 8 | 58 | 1 | |||
| 41271 | 4935 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 28 Dedman Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/16/2013 12:00:00 AM | 3 | 6016539.8066281 | 2096230.011328 | 37.7367766114468 | -122.385269807917 | (37.7367766114468, -122.385269807917) | 10 | 3 | 8 | 58 | 1 | |||
| 84441 | 194989 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 11 Dedman Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6016533.77579 | 2096242.57848 | 37.736810784681 | -122.385291534798 | (37.736810784681, -122.385291534798) | 10 | 3 | 8 | 58 | 1 | |||
| 84468 | 4937 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 31 Dedman Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/16/2013 12:00:00 AM | 3 | 3X4 | 6016529.7381714 | 2096313.4471867 | 37.7370051525187 | -122.38531043158 | (37.7370051525187, -122.38531043158) | 10 | 3 | 8 | 58 | 1 | ||
| 121694 | 4933 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 24 Dedman Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/16/2013 12:00:00 AM | 3 | 6016526.7092076 | 2096227.141084 | 37.7367680057557 | -122.385314891909 | (37.7367680057557, -122.385314891909) | 10 | 3 | 8 | 58 | 1 | |||
| 127359 | 195004 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 50 Dedman Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6016527.61209 | 2096304.47385 | 37.7369803959213 | -122.385317157364 | (37.7369803959213, -122.385317157364) | 10 | 3 | 8 | 58 | 1 | |||
| 68966 | 194988 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 11 Dedman Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6016511.35387 | 2096236.46236 | 37.7367927505907 | -122.385368631877 | (37.7367927505907, -122.385368631877) | 10 | 3 | 8 | 58 | 1 | |||
| 49569 | 195005 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 50 Dedman Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6016499.64724 | 2096292.33943 | 37.7369455301091 | -122.385412999906 | (37.7369455301091, -122.385412999906) | 10 | 3 | 8 | 58 | 1 | |||
| 171209 | 194987 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 11 Dedman Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6016492.60834 | 2096223.59489 | 37.7367563820033 | -122.38543254757 | (37.7367563820033, -122.38543254757) | 10 | 3 | 8 | 58 | 1 | |||
| 4270 | 4929 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 16 Dedman Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/16/2013 12:00:00 AM | 3 | 3X4 | 6016491.974751 | 2096204.2192508 | 37.7367031453425 | -122.385433388359 | (37.7367031453425, -122.385433388359) | 10 | 3 | 8 | 58 | 1 | ||
| 7594 | 194986 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 11 Dedman Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6016473.13756 | 2096210.02869 | 37.7367180546823 | -122.38549892205 | (37.7367180546823, -122.38549892205) | 10 | 3 | 8 | 58 | 1 | |||
| 90403 | 4932 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 21 Dedman Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016472.9364173 | 2096288.1310421 | 37.7369324968906 | -122.385505058787 | (37.7369324968906, -122.385505058787) | 10 | 3 | 8 | 58 | 1 | |||
| 36107 | 195006 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 50 Dedman Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6016468.53452 | 2096275.29989 | 37.7368970215793 | -122.385519384306 | (37.7368970215793, -122.385519384306) | 10 | 3 | 8 | 58 | 1 | |||
| 18285 | 4930 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 17 Dedman Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/16/2013 12:00:00 AM | 3 | 3X4 | 6016453.9870213 | 2096275.6260294 | 37.7368971121848 | -122.385569704648 | (37.7368971121848, -122.385569704648) | 10 | 3 | 8 | 58 | 1 | ||
| 165974 | 200632 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1300x Newcomb Ave | 10 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6016398.592 | 2094838.1728 | 37.7329470887224 | -122.385661077489 | (37.7329470887224, -122.385661077489) | 10 | 3 | 8 | 58 | 1 | |||
| 192504 | 97231 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1300X Newcomb Ave | 11 | Median : Cutout | Tree | DPW 1 | 6 | 15x200 | 6016395.2358 | 2094838.1728 | 37.732946903013 | -122.385672680851 | (37.732946903013, -122.385672680851) | 10 | 3 | 8 | 58 | 1 | |||
| 155933 | 4927 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 11 Dedman Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016420.2742489 | 2096250.3265868 | 37.7368257796139 | -122.385684502976 | (37.7368257796139, -122.385684502976) | 10 | 3 | 8 | 58 | 1 | |||
| 83343 | 97232 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1300X Newcomb Ave | 12 | Median : Cutout | Tree | DPW 1 | 6 | 15x200 | 6016387.2649 | 2094839.0118 | 37.7329487656792 | -122.385700297031 | (37.7329487656792, -122.385700297031) | 10 | 3 | 8 | 58 | 1 | |||
| 31799 | 11399 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1462 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016280.69423 | 2096695.13026 | 37.7380393961916 | -122.386198097279 | (37.7380393961916, -122.386198097279) | 10 | 3 | 8 | 58 | 1 | |||
| 129748 | 195015 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1427x Innes Ave | 14 | Median : Yard | Tree | DPW 1 | 5 | 6016257.18354 | 2096668.39459 | 37.737964684134 | -122.386277522713 | (37.737964684134, -122.386277522713) | 10 | 3 | 8 | 58 | 1 | ||||
| 101021 | 2538 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1575 Burke Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2000 12:00:00 AM | 3 | 3X3 | 6016293.38997 | 2099044.81151 | 37.7444918448175 | -122.386317974213 | (37.7444918448175, -122.386317974213) | 10 | 3 | 8 | 58 | 1 | ||
| 43429 | 2537 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1575 Burke Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/03/2016 12:00:00 AM | 6 | 3X3 | 6016279.43485 | 2099056.14622 | 37.7445221951468 | -122.386367018739 | (37.7445221951468, -122.386367018739) | 10 | 3 | 8 | 58 | 1 | ||
| 125820 | 11412 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1482 Innes Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X4 | 6016154.87706 | 2096787.24136 | 37.7382853499827 | -122.386639534879 | (37.7382853499827, -122.386639534879) | 10 | 3 | 8 | 58 | 1 | |||
| 30648 | 195014 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1409 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6016094.42849 | 2094603.13506 | 37.732284887124 | -122.386696274914 | (37.732284887124, -122.386696274914) | 10 | 3 | 8 | 58 | 1 | |||
| 125004 | 194747 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1580 Burke Ave | 2 | : | Tree | Private 2 | 3 | Width 4ft | 6016181.61808 | 2099214.241 | 37.7449508758992 | -122.386716274933 | (37.7449508758992, -122.386716274933) | 10 | 3 | 8 | 58 | 1 | |||
| 101439 | 26130 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1407 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016047.647 | 2094692.1402 | 37.7325266873331 | -122.38686421566 | (37.7325266873331, -122.38686421566) | 10 | 3 | 8 | 58 | 1 | |||
| 15178 | 26129 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1411 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016032.5768 | 2094704.0708 | 37.7325586119483 | -122.386917149192 | (37.7325586119483, -122.386917149192) | 10 | 3 | 8 | 58 | 1 | |||
| 50806 | 200705 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1462 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6015971.3542 | 2095172.8163 | 37.7338423029692 | -122.387161496165 | (37.7338423029692, -122.387161496165) | 10 | 3 | 8 | 58 | 1 | |||
| 192116 | 199878 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1408 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6015930.5512 | 2093462.2061 | 37.7291430496929 | -122.387183288185 | (37.7291430496929, -122.387183288185) | 10 | 3 | 8 | 58 | 1 | |||
| 26747 | 194877 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 411 China Basin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016229.27559 | 2109093.14578 | 37.7720788903636 | -122.387240442995 | (37.7720788903636, -122.387240442995) | 14 | 3 | 9 | 310 | 20 | |||
| 21757 | 199887 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1501 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6015922.2993 | 2094373.9993 | 37.7316461950184 | -122.387275392579 | (37.7316461950184, -122.387275392579) | 10 | 3 | 8 | 58 | 1 | |||
| 97259 | 194748 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3450 03rd St | 6 | : | Tree | Private 2 | 16 | Width 3ft | 6016023.22407 | 2099430.69434 | 37.7455364415514 | -122.387279073371 | (37.7455364415514, -122.387279073371) | 10 | 3 | 8 | 58 | 1 | |||
| 50293 | 200703 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1470 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6015933.6787 | 2095201.0729 | 37.7339178034813 | -122.387293723271 | (37.7339178034813, -122.387293723271) | 10 | 3 | 8 | 58 | 1 | |||
| 61953 | 22093 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 3400X 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 3 | 3X3 | 6016015.95987 | 2099423.81611 | 37.745517153054 | -122.387303712363 | (37.745517153054, -122.387303712363) | 10 | 3 | 8 | 58 | 1 | |||
| 112543 | 194876 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 411 China Basin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6016202.88987 | 2109091.6784 | 37.7720734000081 | -122.387331611766 | (37.7720734000081, -122.387331611766) | 14 | 3 | 9 | 310 | 20 | |||
| 29525 | 74025 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 409 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6016159.9 | 2106964.2 | 37.766229426257 | -122.387331885576 | (37.766229426257, -122.387331885576) | 14 | 3 | 9 | 310 | 20 | ||
| 51279 | 116420 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 409 Illinois St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6016159.9 | 2106964.2 | 37.766229426257 | -122.387331885576 | (37.766229426257, -122.387331885576) | 14 | 3 | 9 | 310 | 20 | ||||
| 96304 | 72481 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 409 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6016159.9 | 2106964.2 | 37.766229426257 | -122.387331885576 | (37.766229426257, -122.387331885576) | 14 | 3 | 9 | 310 | 20 | ||
| 160187 | 72482 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 409 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6016159.9 | 2106964.2 | 37.766229426257 | -122.387331885576 | (37.766229426257, -122.387331885576) | 14 | 3 | 9 | 310 | 20 | ||
| 16266 | 60348 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1404 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 6 | Permit Number 19926 | 6015899.7652 | 2094527.3411 | 37.7320659929368 | -122.387363991073 | (37.7320659929368, -122.387363991073) | 10 | 3 | 8 | 58 | 1 | |
| 167154 | 194875 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 411 China Basin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6016177.98947 | 2109089.18113 | 37.7720651639932 | -122.387417570779 | (37.7720651639932, -122.387417570779) | 14 | 3 | 9 | 310 | 20 | |||
| 22063 | 93539 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 325 China Basin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | 14 | 3 | 9 | 310 | 20 | ||
| 63825 | 93544 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 325 China Basin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | 14 | 3 | 9 | 310 | 20 | ||
| 92378 | 93540 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 325 China Basin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | 14 | 3 | 9 | 310 | 20 | ||
| 100882 | 93542 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 325 China Basin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | 14 | 3 | 9 | 310 | 20 | ||
| 141658 | 93543 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 325 China Basin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | 14 | 3 | 9 | 310 | 20 | ||
| 188490 | 93541 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 325 China Basin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2010 12:00:00 AM | 3x3 | Permit Number 53240 | 6016190.6 | 2109941.9 | 37.774407241214 | -122.387433446454 | (37.774407241214, -122.387433446454) | 14 | 3 | 9 | 310 | 20 | ||
| 146852 | 194874 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 411 China Basin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6016148.88439 | 2109089.76822 | 37.772065164008 | -122.387518289441 | (37.772065164008, -122.387518289441) | 14 | 3 | 9 | 310 | 20 | |||
| 53264 | 194878 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 414 China Basin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6016145.01396 | 2109134.45243 | 37.772187642686 | -122.387534795613 | (37.772187642686, -122.387534795613) | 14 | 3 | 9 | 310 | 20 | |||
| 26809 | 194873 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 411 China Basin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6016122.98032 | 2109087.29125 | 37.7720569280033 | -122.387607721645 | (37.7720569280033, -122.387607721645) | 14 | 3 | 9 | 310 | 20 | |||
| 129194 | 194857 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 13 Bridgeview Way | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6016092.3761 | 2108385.26667 | 37.7701276268135 | -122.387664596547 | (37.7701276268135, -122.387664596547) | 14 | 3 | 9 | 310 | 20 | |||
| 187298 | 194872 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 411 China Basin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6016098.84287 | 2109085.27848 | 37.7720500643794 | -122.38769107529 | (37.7720500643794, -122.38769107529) | 14 | 3 | 9 | 310 | 20 | |||
| 44581 | 15029 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 900 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/23/2015 12:00:00 AM | 18 | 3X3 | 6015841.7954 | 2096558.94819 | 37.7376411655934 | -122.387706102953 | (37.7376411655934, -122.387706102953) | 10 | 3 | 8 | 58 | 1 | ||
| 6779 | 60387 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1436 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 15 | Permit Number 19967 | 6015759.6141 | 2094635.0651 | 37.7323540184412 | -122.387856042206 | (37.7323540184412, -122.387856042206) | 10 | 3 | 8 | 58 | 1 | |
| 66596 | 194871 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015990.53014 | 2109078.96537 | 37.7720267296814 | -122.388065300271 | (37.7720267296814, -122.388065300271) | 14 | 3 | 9 | 310 | 20 | |||
| 132944 | 200681 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1535 Newcomb Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6015701.3552 | 2095304.4928 | 37.7341889046426 | -122.388104158222 | (37.7341889046426, -122.388104158222) | 10 | 3 | 8 | 58 | 1 | |||
| 11546 | 60372 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1447 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 16 | Permit Number 19950 | 6015678.2715 | 2094616.9279 | 37.7322997108216 | -122.388135999617 | (37.7322997108216, -122.388135999617) | 10 | 3 | 8 | 58 | 1 | |
| 156794 | 194870 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015967.91832 | 2109077.92188 | 37.7720226116927 | -122.388143444175 | (37.7720226116927, -122.388143444175) | 14 | 3 | 9 | 310 | 20 | |||
| 90227 | 194869 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015941.01057 | 2109075.46534 | 37.7720143756979 | -122.388236349523 | (37.7720143756979, -122.388236349523) | 14 | 3 | 9 | 310 | 20 | |||
| 175199 | 96769 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1300X Lane St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 1 | 4x4 | 6015646.9436 | 2095179.7309 | 37.7338433188148 | -122.388283573512 | (37.7338433188148, -122.388283573512) | 10 | 3 | 8 | 58 | 1 | ||
| 143630 | 194868 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015915.65393 | 2109075.22699 | 37.7720123162411 | -122.388324044236 | (37.7720123162411, -122.388324044236) | 14 | 3 | 9 | 310 | 20 | |||
| 14678 | 96770 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1300X Lane St | 6 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12/08/2012 12:00:00 AM | 3 | 3x3 | 6015623.8599 | 2095148.9526 | 37.7337575287133 | -122.388361234061 | (37.7337575287133, -122.388361234061) | 10 | 3 | 8 | 58 | 1 | |
| 48150 | 194867 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015891.51619 | 2109073.21474 | 37.7720054535224 | -122.388407398805 | (37.7720054535224, -122.388407398805) | 14 | 3 | 9 | 310 | 20 | |||
| 191214 | 194752 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1551 Fairfax Ave | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6015647.85994 | 2098132.60328 | 37.7419513562614 | -122.388486445597 | (37.7419513562614, -122.388486445597) | 10 | 3 | 8 | 58 | 1 | |||
| 190570 | 194866 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015868.42271 | 2109073.181 | 37.7720040811672 | -122.388487279274 | (37.7720040811672, -122.388487279274) | 14 | 3 | 9 | 310 | 20 | |||
| 33267 | 26138 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1500 Oakdale Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 11/05/2005 12:00:00 AM | 3 | 3x3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | ||
| 163054 | 26140 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1500 Oakdale Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/21/2006 12:00:00 AM | 2 | 3x3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | ||
| 174220 | 194753 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1550 Fairfax Ave | 4 | : | Tree | Private 2 | 2 | Width 3ft | 6015617.8277 | 2098227.3479 | 37.7422098412063 | -122.388596900349 | (37.7422098412063, -122.388596900349) | 10 | 3 | 8 | 58 | 1 | |||
| 165052 | 194803 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 503 Beale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6015935.90952 | 2113992.90584 | 37.785516288784 | -122.38859731131 | (37.785516288784, -122.38859731131) | 6 | 2 | 9 | 28856 | 6 | |||
| 165951 | 194751 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1551 Fairfax Ave | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6015611.29457 | 2098161.01371 | 37.7420273390937 | -122.388614860703 | (37.7420273390937, -122.388614860703) | 10 | 3 | 8 | 58 | 1 | |||
| 43096 | 26132 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1502 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 3x3 | 6015548.0134 | 2095134.6627 | 37.7337140884108 | -122.388622463057 | (37.7337140884108, -122.388622463057) | 10 | 3 | 8 | 58 | 1 | |||
| 140195 | 194865 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015826.7116 | 2109071.02334 | 37.7719958451713 | -122.38863141183 | (37.7719958451713, -122.38863141183) | 14 | 3 | 9 | 310 | 20 | |||
| 79566 | 194754 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1550 Fairfax Ave | 5 | : | Tree | Private 2 | 3 | Width 3ft | 6015607.64165 | 2098237.38094 | 37.742236825364 | -122.388632821062 | (37.742236825364, -122.388632821062) | 10 | 3 | 8 | 58 | 1 | |||
| 158851 | 194804 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 503 Beale St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6015924.34546 | 2114008.18628 | 37.7855576045419 | -122.388638386948 | (37.7855576045419, -122.388638386948) | 6 | 2 | 9 | 28856 | 6 | |||
| 4909 | 194805 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 503 Beale St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6015913.1436 | 2114020.02003 | 37.7855894765281 | -122.388677968825 | (37.7855894765281, -122.388677968825) | 6 | 2 | 9 | 28856 | 6 | |||
| 11527 | 50695 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 4 | Permit Number 47259 | 6015937.15224 | 2115364.30383 | 37.7892819048945 | -122.388688779581 | (37.7892819048945, -122.388688779581) | 6 | 2 | 9 | 28855 | 6 | |
| 14807 | 194864 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015802.5335 | 2109067.01209 | 37.7719834911837 | -122.38871476639 | (37.7719834911837, -122.38871476639) | 14 | 3 | 9 | 310 | 20 | |||
| 10530 | 50696 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 4 | Permit Number 47259 | 6015925.73831 | 2115354.86226 | 37.7892553479159 | -122.388727611399 | (37.7892553479159, -122.388727611399) | 6 | 2 | 9 | 28855 | 6 | |
| 92363 | 194806 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 503 Beale St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6015898.48961 | 2114031.92346 | 37.785621348501 | -122.388729499078 | (37.785621348501, -122.388729499078) | 6 | 2 | 9 | 28856 | 6 | |||
| 87667 | 54820 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1427 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1972 12:00:00 AM | 9 | Permit Number 10674 | 6015472.1669 | 2093023.0524 | 37.7279118262719 | -122.388737329628 | (37.7279118262719, -122.388737329628) | 10 | 3 | 8 | 58 | 1 | ||
| 88898 | 194755 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1550 Fairfax Ave | 7 | : | Tree | Private 2 | 2 | Width 3ft | 6015576.67824 | 2098260.2473 | 37.7422978956385 | -122.388741479833 | (37.7422978956385, -122.388741479833) | 10 | 3 | 8 | 58 | 1 | |||
| 14640 | 50694 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 3 | Permit Number 47259 | 6015915.16555 | 2115344.32909 | 37.7892258402606 | -122.388763456582 | (37.7892258402606, -122.388763456582) | 6 | 2 | 9 | 28855 | 6 | |
| 67338 | 194807 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 503 Beale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6015887.13283 | 2114046.76968 | 37.7856614834305 | -122.388769827389 | (37.7856614834305, -122.388769827389) | 6 | 2 | 9 | 28856 | 6 |
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) );