Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 185253 | 185253 | 38724 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 439 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 7 | Permit Number 45328 | 5984981.48092 | 2112906.9180099997 | 37.7807703956275 | -122.49560882850099 | (37.7807703956275, -122.495608828501) | |
| 31112 | 31112 | 182277 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1496 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5984986.5972 | 2105032.276 | 37.7591491619575 | -122.49501031089399 | (37.7591491619575, -122.495010310894) | |||
| 124445 | 124445 | 60548 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 511 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20158 | 5984997.83219607 | 2112387.91202298 | 37.7793463125181 | -122.495513971823 | (37.7793463125181, -122.495513971823) | ||
| 180542 | 180542 | 118261 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 507 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5984999.83681 | 2112374.81786 | 37.779310477103294 | -122.49550607110599 | (37.7793104771033, -122.495506071106) | |||
| 159055 | 159055 | 118259 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 695 35th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5985041.90756 | 2111187.95569 | 37.776054158075496 | -122.495272982569 | (37.7760541580755, -122.495272982569) | |||
| 150768 | 150768 | 60565 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 695 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 6 | Permit Number 20175 | 5985042.36004 | 2111233.42242 | 37.7761790231769 | -122.49527477111299 | (37.7761790231769, -122.495274771113) | |
| 38436 | 38436 | 118260 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 695 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5985042.55881 | 2111210.42257 | 37.7761158838188 | -122.49527238698201 | (37.7761158838188, -122.495272386982) | |||
| 36802 | 36802 | 118258 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 695 35th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5985042.66703 | 2111167.00332 | 37.7759966733376 | -122.49526880989201 | (37.7759966733376, -122.495268809892) | |||
| 139173 | 139173 | 60546 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 500 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20156 | 5985047.62508393 | 2112456.532077 | 37.7795376389344 | -122.495346781978 | (37.7795376389344, -122.495346781978) | ||
| 35350 | 35350 | 60550 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 538 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 4 | Permit Number 20160 | 5985052.81447 | 2112190.6948599997 | 37.7788080303748 | -122.49530921969601 | (37.7788080303748, -122.495309219696) | |
| 46060 | 46060 | 54016 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 847 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1987 12:00:00 AM | 4 | Permit Number 24534 | 5985079.41944 | 2110081.62617 | 37.773018689528705 | -122.495061623329 | (37.7730186895287, -122.495061623329) | ||
| 126052 | 126052 | 60556 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 642 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20166 | 5985080.35984143 | 2111485.8092912 | 37.7768742299218 | -122.495161937272 | (37.7768742299218, -122.495161937272) | ||
| 45507 | 45507 | 118199 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 822 35th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5985120.9222800005 | 2110249.67215 | 37.773482525488 | -122.49493045493601 | (37.773482525488, -122.494930454936) | |||
| 76614 | 76614 | 118201 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 822 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5985121.13264 | 2110239.83023 | 37.7734555146959 | -122.49492900146099 | (37.7734555146959, -122.494929001461) | |||
| 74886 | 74886 | 118200 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 822 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5985121.235230001 | 2110244.64202 | 37.773468732504796 | -122.49492900145201 | (37.7734687325048, -122.494929001452) | |||
| 186476 | 186476 | 54020 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 862 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/1972 12:00:00 AM | 13 | Permit Number 9739 | 5985131.43408 | 2109993.46709 | 37.7727796747305 | -122.49487519957701 | (37.7727796747305, -122.494875199577) | ||
| 55798 | 55798 | 54057 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 874 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1972 12:00:00 AM | 8 | Permit Number 9779 | 5985134.071 | 2109910.10647 | 37.772550944555704 | -122.49485993091601 | (37.7725509445557, -122.494859930916) | ||
| 171300 | 171300 | 50247 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1290 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 4 | Permit Number 46952 | 5985247.4505 | 2106436.1626 | 37.7630191105165 | -122.49421164497801 | (37.7630191105165, -122.494211644978) | |
| 149548 | 149548 | 47797 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2728 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2002 12:00:00 AM | 2 | Permit Number 45569 | 5985267.4757 | 2096643.9771 | 37.7361336146609 | -122.49342088098601 | (37.7361336146609, -122.493420880986) | |
| 40927 | 40927 | 43854 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2750 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 5 | Permit Number 43475 | 5985271.1902 | 2096508.1321 | 37.7357608377733 | -122.49339803308001 | (37.7357608377733, -122.49339803308) | |
| 151322 | 151322 | 43853 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2750 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 5 | Permit Number 43475 | 5985271.7208 | 2096492.7434 | 37.735718615539795 | -122.493395065181 | (37.7357186155398, -122.493395065181) | |
| 37562 | 37562 | 43855 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2762 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 5 | Permit Number 43476 | 5985275.17 | 2096431.4539 | 37.7355505326544 | -122.493378625972 | (37.7355505326544, -122.493378625972) | |
| 40267 | 40267 | 43856 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2770 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43477 | 5985275.7006 | 2096383.1652 | 37.7354179757794 | -122.49337323491999 | (37.7354179757794, -122.49337323492) | |
| 37630 | 37630 | 92414 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2780 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52807 | 5985278.8845 | 2096306.2218 | 37.7352068959215 | -122.49335656011499 | (37.7352068959215, -122.493356560115) |
| 45865 | 45865 | 43858 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2788 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 3 | Permit Number 43479 | 5985280.4764 | 2096241.4831 | 37.735029233793 | -122.49334628832399 | (37.735029233793, -122.493346288324) | |
| 31189 | 31189 | 43857 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2784 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43478 | 5985281.0071 | 2096265.8928 | 37.7350962873764 | -122.493346251334 | (37.7350962873764, -122.493346251334) | |
| 127915 | 127915 | 60534 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 503 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20144 | 5985302.93210533 | 2112455.93467677 | 37.7795509437581 | -122.494463534746 | (37.7795509437581, -122.494463534746) | ||
| 172759 | 172759 | 60538 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 559 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 11 | Permit Number 20148 | 5985322.95349 | 2112076.73738 | 37.778510948720495 | -122.494366313855 | (37.7785109487205, -122.494366313855) | |
| 159371 | 159371 | 184131 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1642 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985330.3253 | 2104026.0743 | 37.7564065269094 | -122.49374740508001 | (37.7564065269094, -122.49374740508) | |||
| 180738 | 180738 | 73681 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 659 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 7 | 5985344.08684 | 2111396.3012599996 | 37.7766439029573 | -122.494243039831 | (37.7766439029573, -122.494243039831) | ||
| 46621 | 46621 | 118245 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 691 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5985349.3641 | 2111245.79185 | 37.7762309559949 | -122.49421368828001 | (37.7762309559949, -122.49421368828) | |||
| 36025 | 36025 | 118247 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 691 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5985350.03778 | 2111197.78577 | 37.7760991844496 | -122.49420781867599 | (37.7760991844496, -122.494207818676) | |||
| 47970 | 47970 | 118246 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 691 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5985350.64255 | 2111226.1623400003 | 37.776177133786 | -122.494207818673 | (37.776177133786, -122.494207818673) | |||
| 68196 | 68196 | 118248 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 691 34th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5985351.9374 | 2111175.43907 | 37.7760379379613 | -122.494199600003 | (37.7760379379613, -122.494199600003) | |||
| 76656 | 76656 | 118187 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 670 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5985391.68749 | 2111321.69007 | 37.776441827373 | -122.494072877364 | (37.776441827373, -122.494072877364) | |||
| 156545 | 156545 | 60545 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 670 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 5 | Permit Number 20155 | 5985392.87012 | 2111306.3977799998 | 37.776399908318 | -122.49406765904 | (37.776399908318, -122.49406765904) | |
| 133987 | 133987 | 43866 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2400 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 3 | Permit Number 43482 | 5985433.3707 | 2096944.3874 | 37.736968163882 | -122.492869443228 | (37.736968163882, -122.492869443228) | |
| 28323 | 28323 | 43865 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2400 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 2 | Permit Number 43482 | 5985465.207 | 2096960.4516 | 37.7370141335806 | -122.49276055533998 | (37.7370141335806, -122.49276055534) | |
| 147849 | 147849 | 43864 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2400 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 2 | Permit Number 43482 | 5985483.3156 | 2096968.9217 | 37.7370384491068 | -122.492698570334 | (37.7370384491068, -122.492698570334) | |
| 70482 | 70482 | 56342 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2318 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/1973 12:00:00 AM | 4 | Permit Number 12482 | 5985490.0114 | 2099405.6778 | 37.743729519488504 | -122.492854850837 | (37.7437295194885, -122.492854850837) | ||
| 154382 | 154382 | 43823 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2506 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 2 | Permit Number 43451 | 5985533.196 | 2098135.2214 | 37.7402437129791 | -122.492611983862 | (37.7402437129791, -122.492611983862) | |
| 178923 | 178923 | 43827 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2660 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 2 | Permit Number 43455 | 5985563.587 | 2097218.3186 | 37.7377279199374 | -122.492439400495 | (37.7377279199374, -122.492439400495) | |
| 159302 | 159302 | 183386 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2666 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5985564.6384 | 2097173.3171 | 37.7376044192908 | -122.492432452337 | (37.7376044192908, -122.492432452337) | |||
| 42033 | 42033 | 43829 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2676 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43457 | 5985566.531 | 2097143.2459 | 37.737521962445705 | -122.49242369498 | (37.7375219624457, -122.49242369498) | |
| 149680 | 149680 | 43830 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2676 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 3 | Permit Number 43457 | 5985567.1619 | 2097124.1097 | 37.7374694564281 | -122.492420104896 | (37.7374694564281, -122.492420104896) | |
| 144205 | 144205 | 43828 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2670 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | Permit Number 43456 | 5985569.7660806 | 2097142.61750011 | 37.737520426167 | -122.492412463677 | (37.737520426167, -122.492412463677) | ||
| 56100 | 56100 | 43841 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2724 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 3 | Permit Number 43463 | 5985577.466 | 2096809.3090000001 | 37.736605699985205 | -122.49236130454399 | (37.7366056999852, -122.492361304544) | |
| 67394 | 67394 | 182513 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1573 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5985578.9968 | 2104511.5721 | 37.757754115031794 | -122.492923184352 | (37.7577541150318, -122.492923184352) | |||
| 155122 | 155122 | 69455 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 467 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 5 | Permit Number 33565 | 5985605.56092 | 2112752.97271 | 37.780384231502 | -122.49343851854601 | (37.780384231502, -122.493438518546) | |
| 187950 | 187950 | 45592 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1767 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 2 | Permit Number 44328 | 5985625.0375 | 2103206.7223 | 37.754174049116294 | -122.492667858454 | (37.7541740491163, -122.492667858454) | |
| 99194 | 99194 | 90973 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 3201 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/13/2008 12:00:00 AM | 3 | 3x3 | 5985628.516480001 | 2111090.85012 | 37.775821861569 | -122.493236620395 | (37.775821861569, -122.493236620395) | ||
| 36455 | 36455 | 78402 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 593 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 4 | 5985636.206590001 | 2111885.61878 | 37.7780045190041 | -122.493268584238 | (37.7780045190041, -122.493268584238) | ||
| 59037 | 59037 | 78388 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 593 33rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 4 | 5985636.69851 | 2111874.46867 | 37.7779739327663 | -122.493266060875 | (37.7779739327663, -122.493266060875) | ||
| 168091 | 168091 | 45594 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1843 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 4 | Permit Number 44330 | 5985644.082 | 2102671.8491 | 37.7527065474657 | -122.492562610112 | (37.7527065474657, -122.492562610112) | |
| 94989 | 94989 | 43615 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1931 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43268 | 5985659.54390189 | 2102074.20196497 | 37.7510664757994 | -122.492465132432 | (37.7510664757994, -122.492465132432) | ||
| 185095 | 185095 | 45589 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1758 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 3 | Permit Number 44325 | 5985669.1963 | 2103253.8848 | 37.7543061263725 | -122.49251862163 | (37.7543061263725, -122.49251862163) | |
| 49668 | 49668 | 45591 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1762 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 2 | Permit Number 44327 | 5985671.2041 | 2103229.2894 | 37.754238711545604 | -122.492509867059 | (37.7542387115456, -122.492509867059) | |
| 135641 | 135641 | 95449 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2215 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767310 | 5985728.4893 | 2100116.7504 | 37.7456958759077 | -122.492082607258 | (37.7456958759077, -122.492082607258) |
| 150550 | 150550 | 33157 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2340 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 1 | Permit Number 37380 | 5985804.6591 | 2099281.9 | 37.7434080538941 | -122.491757779517 | (37.7434080538941, -122.491757779517) | |
| 134363 | 134363 | 38125 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1227 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | 6 | Permit Number 40289 | 5985809.4521 | 2106852.3507 | 37.7641947180189 | -122.49229854917 | (37.7641947180189, -122.49229854917) | |
| 184237 | 184237 | 185131 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2665 34th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5985814.4377 | 2097199.1641 | 37.737689989794895 | -122.49157069147199 | (37.7376899897949, -122.491570691472) | |||
| 40407 | 40407 | 250787 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 277 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5985873.31121 | 2114054.8468299997 | 37.7839744613866 | -122.49260816604601 | (37.7839744613866, -122.492608166046) | |||
| 188321 | 188321 | 181941 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2338 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985894.7639 | 2098931.5489 | 37.7424513496728 | -122.49142044264 | (37.7424513496728, -122.49142044264) | |||
| 66286 | 66286 | 250757 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 206 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5985901.09635 | 2114492.32613 | 37.785177277657496 | -122.492544270121 | (37.7851772776575, -122.492544270121) | |||
| 154941 | 154941 | 184141 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1647 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5985907.4128 | 2104010.0255 | 37.756396206392104 | -122.49175048083599 | (37.7563962063921, -122.491750480836) | |||
| 134897 | 134897 | 250785 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 270 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5985911.734180001 | 2114095.33531 | 37.784087877591794 | -122.492478221206 | (37.7840878775918, -122.492478221206) | |||
| 22877 | 22877 | 58835 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 465 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1984 12:00:00 AM | 12 | Permit Number 21290 | 5985916.00894 | 2112750.62267 | 37.7803959336596 | -122.492364376017 | (37.7803959336596, -122.492364376017) | ||
| 24610 | 24610 | 183977 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1693 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5985918.7806 | 2103713.7918 | 37.7555834944248 | -122.49168936146002 | (37.7555834944248, -122.49168936146) | |||
| 12968 | 12968 | 35485 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1518 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/1998 12:00:00 AM | 5 | 3x3 | Permit Number 38896 | 5985922.1706 | 2104864.8854 | 37.7587442786876 | -122.49176237341999 | (37.7587442786876, -122.49176237342) | |
| 39747 | 39747 | 182785 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1771 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5985934.7262 | 2103202.6862 | 37.754181070474296 | -122.491596596474 | (37.7541810704743, -122.491596596474) | |||
| 48434 | 48434 | 182802 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1771 33rd Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5985936.734 | 2103180.0986 | 37.7541191684466 | -122.491587990539 | (37.7541191684466, -122.491587990539) | |||
| 50209 | 50209 | 182801 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1771 33rd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985937.2360000005 | 2103186.122 | 37.7541357363912 | -122.49158669787799 | (37.7541357363912, -122.491586697878) | |||
| 147802 | 147802 | 43614 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2307 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | 0 | Permit Number 43267 | 5986057.74233094 | 2099524.76876383 | 37.74408969471521 | -122.49090056184099 | (37.7440896947152, -122.490900561841) | |
| 36440 | 36440 | 181892 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2363 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986073.9582 | 2099148.308 | 37.7430569818271 | -122.490816796777 | (37.7430569818271, -122.490816796777) | |||
| 86116 | 86116 | 185234 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2530 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5986160.02 | 2098006.6727 | 37.739927383563 | -122.49043525338301 | (37.739927383563, -122.490435253383) | |||
| 168487 | 168487 | 250795 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 290 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986226.21568 | 2113977.7713599997 | 37.7837834624768 | -122.491381587892 | (37.7837834624768, -122.491381587892) | |||
| 41962 | 41962 | 250796 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 290 31st Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986226.25026 | 2113990.91468 | 37.7838195522695 | -122.49138243596201 | (37.7838195522695, -122.491382435962) | |||
| 45999 | 45999 | 56975 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1739 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1974 12:00:00 AM | 4 | Permit Number 14228 | 5986239.2634 | 2103387.2054 | 37.7547055025231 | -122.490557020674 | (37.7547055025231, -122.490557020674) | ||
| 137034 | 137034 | 45588 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1855 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 2 | Permit Number 44324 | 5986264.8531 | 2102615.7114 | 37.7525886851651 | -122.490411772937 | (37.7525886851651, -122.490411772937) | |
| 28964 | 28964 | 185787 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1955 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986290.3574 | 2101933.6233 | 37.7507173462216 | -122.490273404856 | (37.7507173462216, -122.490273404856) | |||
| 33147 | 33147 | 78042 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1975 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/2000 12:00:00 AM | 2 | 5986293.4379 | 2101820.6717 | 37.7504073916771 | -122.490254444499 | (37.7504073916771, -122.490254444499) | ||
| 68750 | 68750 | 96491 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2018 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2011 12:00:00 AM | 2 | Permit Number 767862 | 5986347.5106 | 2101481.4472 | 37.7494791308709 | -122.490042511756 | (37.7494791308709, -122.490042511756) | ||
| 73525 | 73525 | 42869 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2463 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 6 | Permit Number 42792 | 5986405.95 | 2098491.0929 | 37.741271833428 | -122.48962055514299 | (37.741271833428, -122.489620555143) | |
| 65014 | 65014 | 33152 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2338 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 4 | Permit Number 37375 | 5986424.393999999 | 2099328.856 | 37.7435731839429 | -122.48961837521401 | (37.7435731839429, -122.489618375214) | |
| 93097 | 93097 | 42873 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2591 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | Permit Number 42797 | 5986433.82928872 | 2097628.34925151 | 37.7389045964665 | -122.48946073616001 | (37.7389045964665, -122.48946073616) | ||
| 161072 | 161072 | 119574 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 341 30th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5986512.996119999 | 2113510.70001 | 37.782517772266004 | -122.490355077371 | (37.782517772266, -122.490355077371) | |||
| 152802 | 152802 | 182231 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1422 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986519.8619 | 2105540.5467 | 37.760634373073295 | -122.489744999655 | (37.7606343730733, -122.489744999655) | |||
| 72072 | 72072 | 119943 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 354 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5986555.85963 | 2113549.68684 | 37.7826273222461 | -122.490209658988 | (37.7826273222461, -122.490209658988) | |||
| 38014 | 38014 | 43592 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1943 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | 3 | Permit Number 43253 | 5986599.433999999 | 2102022.9577 | 37.750980680205004 | -122.48921117318399 | (37.750980680205, -122.489211173184) | |
| 61747 | 61747 | 50217 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 734@ BALBOA 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/2003 12:00:00 AM | 4 | Permit Number 46924 | 5986651.4540800005 | 2110915.11832 | 37.775399129144 | -122.489685140802 | (37.775399129144, -122.489685140802) | |
| 181653 | 181653 | 42856 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2551 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 4 | Permit Number 42785 | 5986738.9077 | 2097900.6980000003 | 37.7396701992704 | -122.488425940896 | (37.7396701992704, -122.488425940896) | |
| 105641 | 105641 | 42860 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2599 31st Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2000 12:00:00 AM | Permit Number 42787 | 5986745.41813509 | 2097587.07290157 | 37.7388094476944 | -122.488380388139 | (37.7388094476944, -122.488380388139) | |||
| 164574 | 164574 | 42867 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2642 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 6 | Permit Number 42790 | 5986758.276000001 | 2097325.1888 | 37.7380911334224 | -122.488316691863 | (37.7380911334224, -122.488316691863) | |
| 186371 | 186371 | 43586 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1983 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | 2 | Permit Number 43247 | 5986913.6448 | 2101776.5179 | 37.7503223588527 | -122.48810650903799 | (37.7503223588527, -122.488106509038) | |
| 59514 | 59514 | 43587 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2006 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | 1 | Permit Number 43248 | 5986971.0019 | 2101586.3374 | 37.7498035204361 | -122.48789419534701 | (37.7498035204361, -122.487894195347) | |
| 183656 | 183656 | 67964 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 886 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 5 | Permit Number 31685 | 5986990.83433 | 2109932.0765299997 | 37.7727197817537 | -122.488438897232 | (37.7727197817537, -122.488438897232) | |
| 44957 | 44957 | 50214 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 890@ FULTON 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/2003 12:00:00 AM | 5 | Permit Number 46922 | 5986992.86494 | 2109903.65169 | 37.7726418536031 | -122.488429783803 | (37.7726418536031, -122.488429783803) | |
| 24704 | 24704 | 50215 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 894@ CABRILLO 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/2003 12:00:00 AM | 6 | Permit Number 46923 | 5986993.182990001 | 2109884.80336 | 37.7725901199359 | -122.488427298171 | (37.7725901199359, -122.488427298171) | |
| 34260 | 34260 | 67963 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 882 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 6 | Permit Number 31684 | 5986994.57488 | 2109967.9859599997 | 37.7728185972219 | -122.48842859801701 | (37.7728185972219, -122.488428598017) | |
| 142188 | 142188 | 50216 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 894@ CABRILLO 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/21/2003 12:00:00 AM | Permit Number 46923 | 5987003.09791718 | 2109853.91131162 | 37.772505877548106 | -122.48839073113501 | (37.7725058775481, -122.488390731135) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");