Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22132 | 22132 | 28299 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 100 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 5995861.9776 | 2088092.909 | 37.713268452474104 | -122.45617353106701 | (37.7132684524741, -122.456173531067) | |||
| 35602 | 35602 | 217547 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 102 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5995842.2441 | 2088093.8487 | 37.713269899907104 | -122.45624180431801 | (37.7132698999071, -122.456241804318) | |||
| 11043 | 11043 | 15768 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 4770 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 15 | 3x3 | 6001444.506 | 2091085.1877 | 37.721803449313896 | -122.437092531149 | (37.7218034493139, -122.437092531149) | ||
| 68178 | 68178 | 32290 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1400 Egbert Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | 13 | Permit Number 36872 | 6014301.1518 | 2091179.5011 | 37.7227848326743 | -122.392656680249 | (37.7227848326743, -122.392656680249) | ||
| 12618 | 12618 | 15750 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 4625 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6002067.6674 | 2091962.7327 | 37.7242483928285 | -122.43500115616301 | (37.7242483928285, -122.435001156163) | |||
| 60326 | 60326 | 187453 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 4621 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6002078.4831 | 2091980.9842 | 37.724299121454 | -122.43496507260201 | (37.724299121454, -122.434965072602) | |||
| 20249 | 20249 | 25265 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1738 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 5994685.8034 | 2092359.9129 | 37.7249170424989 | -122.46054777423099 | (37.7249170424989, -122.460547774231) | |||
| 174955 | 174955 | 199852 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2501 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6014213.4453 | 2092166.8088 | 37.7254909106612 | -122.393028911239 | (37.7254909106612, -122.393028911239) | |||
| 133602 | 133602 | 199721 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2300 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6015103.6937 | 2092236.9895 | 37.7257330254006 | -122.389956274684 | (37.7257330254006, -122.389956274684) | |||
| 74755 | 74755 | 199769 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1197 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6016909.41 | 2092306.5247 | 37.726023933628895 | -122.383718829233 | (37.7260239336289, -122.383718829233) | |||
| 175898 | 175898 | 199982 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1081 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6018036.5838 | 2092513.2332 | 37.7266537566215 | -122.379836574534 | (37.7266537566215, -122.379836574534) | |||
| 74499 | 74499 | 199975 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1233 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016858.7319 | 2092693.7716 | 37.7270844364031 | -122.38392097441299 | (37.7270844364031, -122.383920974413) | |||
| 176490 | 176490 | 38608 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1570 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/2003 12:00:00 AM | 6 | Permit Number 45423 | 6015284.7491 | 2094285.2369 | 37.7313671428977 | -122.38947335260099 | (37.7313671428977, -122.389473352601) | |
| 16688 | 16688 | 97242 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1300X Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016235.0824 | 2094868.9009 | 37.7330224130953 | -122.386228519291 | (37.7330224130953, -122.386228519291) | |||
| 4602 | 4602 | 245382 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 3720 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6005277.267000001 | 2096556.8057 | 37.7370444205252 | -122.42423260748899 | (37.7370444205252, -122.424232607489) | |||
| 67059 | 67059 | 185225 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2519 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5985800.5083 | 2098072.0747 | 37.7400859553966 | -122.491683090969 | (37.7400859553966, -122.491683090969) | |||
| 71966 | 71966 | 182128 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2650 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5987739.3319 | 2098310.7141 | 37.7408543176455 | -122.48499701931601 | (37.7408543176455, -122.484997019316) | |||
| 134981 | 134981 | 182109 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2443 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5987643.897000001 | 2098649.745 | 37.741779647708995 | -122.48535186527599 | (37.741779647709, -122.485351865276) | |||
| 31784 | 31784 | 98024 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1639 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5988098.058999999 | 2098940.517 | 37.742604479099 | -122.483802857352 | (37.742604479099, -122.483802857352) | |||
| 188134 | 188134 | 181943 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1635 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5988119.3796 | 2098941.1939 | 37.7426075787892 | -122.483729187458 | (37.7426075787892, -122.483729187458) | |||
| 29051 | 29051 | 181932 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2378 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 0ft | 5985195.246 | 2099024.2764 | 37.74266505256279 | -122.49384596323 | (37.7426650525628, -122.49384596323) | |||
| 58272 | 58272 | 181891 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2362 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5985808.0433 | 2099163.7908 | 37.7430839555722 | -122.491737385137 | (37.7430839555722, -122.491737385137) | |||
| 74885 | 74885 | 97311 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 926 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/1984 12:00:00 AM | 7 | 3x3 | 5990303.3847 | 2099082.1466 | 37.7431214880079 | -122.47618790715099 | (37.7431214880079, -122.476187907151) | ||
| 20080 | 20080 | 38646 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 209 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1998 12:00:00 AM | Permit Number 40570 | 6005214.92856016 | 2099001.03793316 | 37.7437522091261 | -122.42462195934401 | (37.7437522091261, -122.424621959344) | |||
| 39439 | 39439 | 181853 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2318 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5986420.3329 | 2099445.95 | 37.7438944556176 | -122.48964102637699 | (37.7438944556176, -122.489641026377) | |||
| 133205 | 133205 | 62731 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2307 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1993 12:00:00 AM | 10 | Permit Number 32015 | 5985442.2939 | 2099497.5593 | 37.7439790107491 | -122.49302661105 | (37.7439790107491, -122.49302661105) | ||
| 159251 | 159251 | 183822 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2235 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5987905.4957 | 2100075.9969 | 37.7457109948541 | -122.484551945811 | (37.7457109948541, -122.484551945811) | |||
| 78346 | 78346 | 113409 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 401x DUNCAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003916.0 | 2099815.0 | 37.745913716911 | -122.429171370863 | (37.745913716911, -122.429171370863) | ||||
| 139908 | 139908 | 37062 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1450 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1998 12:00:00 AM | 3x3 | Permit Number 39663 | 6003906.83973736 | 2099821.31146391 | 37.745930528166596 | -122.429203495744 | (37.7459305281666, -122.429203495744) | ||
| 183473 | 183473 | 184489 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1866 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5983834.6211 | 2102450.9664 | 37.7519941007524 | -122.49880363397499 | (37.7519941007524, -122.498803633975) | |||
| 157088 | 157088 | 184487 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1862 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5983833.6059 | 2102475.6712 | 37.75206187373821 | -122.498808969569 | (37.7520618737382, -122.498808969569) | |||
| 19885 | 19885 | 549 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2899 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009532.5718 | 2102167.7354 | 37.7526901583127 | -122.40991601243401 | (37.7526901583127, -122.409916012434) | |||
| 60650 | 60650 | 245421 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2895 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6009555.5127 | 2102167.7354 | 37.752691443997996 | -122.40983667839501 | (37.752691443998, -122.409836678395) | |||
| 17292 | 17292 | 540 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2869 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6009646.1294 | 2102175.7647 | 37.75271856860871 | -122.409523875049 | (37.7527185686087, -122.409523875049) | |||
| 10272 | 10272 | 531 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2847 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 3x3 | 6009825.6422 | 2102183.2205 | 37.752749097586296 | -122.408903610932 | (37.7527490975863, -122.408903610932) | |||
| 133730 | 133730 | 245419 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2839 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6009862.9212 | 2102186.0881 | 37.7527590594841 | -122.408774895147 | (37.7527590594841, -122.408774895147) | |||
| 17429 | 17429 | 529 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2833 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009902.781 | 2102188.0955 | 37.7527668038666 | -122.408637193736 | (37.7527668038666, -122.408637193736) | |||
| 19545 | 19545 | 520 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2809 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 5x5 | 6009957.8393 | 2102189.816 | 37.752774611473995 | -122.408446912653 | (37.752774611474, -122.408446912653) | |||
| 17142 | 17142 | 545 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2878 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6009558.0762 | 2102211.8871 | 37.7528128183786 | -122.40983092966101 | (37.7528128183786, -122.409830929661) | |||
| 21819 | 21819 | 544 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2872 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009585.3031 | 2102212.4790000003 | 37.752815969417206 | -122.409736815429 | (37.7528159694172, -122.409736815429) | |||
| 17565 | 17565 | 542 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2870 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6009603.0598 | 2102213.6628 | 37.7528202149244 | -122.40967549279199 | (37.7528202149244, -122.409675492792) | |||
| 17198 | 17198 | 538 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2860 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009651.0028 | 2102218.3979 | 37.7528359029411 | -122.409510030546 | (37.7528359029411, -122.409510030546) | |||
| 22134 | 22134 | 532 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2850 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009709.5998 | 2102220.1735 | 37.7528440615121 | -122.409307515735 | (37.7528440615121, -122.409307515735) | |||
| 21717 | 21717 | 491 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2749X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6010371.9231 | 2102214.4775 | 37.7528655070754 | -122.40701666692699 | (37.7528655070754, -122.407016666927) | |||
| 19393 | 19393 | 527 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2836 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6009841.2951 | 2102226.6843 | 37.7528693162895 | -122.408852546362 | (37.7528693162895, -122.408852546362) | |||
| 21970 | 21970 | 524 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2826 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6009890.4218 | 2102229.0519 | 37.752878568819796 | -122.408682823354 | (37.7528785688198, -122.408682823354) | |||
| 17455 | 17455 | 519 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2802 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6009998.1456 | 2102238.5221 | 37.7529106047271 | -122.408310960592 | (37.7529106047271, -122.408310960592) | |||
| 1775 | 1775 | 245411 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2794 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6010069.4683 | 2102240.5937 | 37.7529202865107 | -122.408064458251 | (37.7529202865107, -122.408064458251) | |||
| 18297 | 18297 | 513 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2792 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010090.1844 | 2102241.1856 | 37.752923071613495 | -122.40799285948499 | (37.7529230716135, -122.407992859485) | |||
| 17799 | 17799 | 514 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2790 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6010107.5289 | 2102242.0067 | 37.752926297242205 | -122.407932936557 | (37.7529262972422, -122.407932936557) | |||
| 1904 | 1904 | 245410 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2782 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6010125.3081 | 2102244.3008 | 37.752933591707794 | -122.40787161420401 | (37.7529335917078, -122.407871614204) | |||
| 39668 | 39668 | 245409 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2778 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6010163.1606 | 2102247.1684 | 37.7529435845832 | -122.40774091468 | (37.7529435845832, -122.40774091468) | |||
| 20773 | 20773 | 501 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2754 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5x5 | 6010215.9248 | 2102247.7419 | 37.7529481129231 | -122.40755848565901 | (37.7529481129231, -122.407558485659) | |||
| 18753 | 18753 | 498 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2752 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010250.9097 | 2102250.6095 | 37.7529579449469 | -122.40743770281999 | (37.7529579449469, -122.40743770282) | |||
| 130123 | 130123 | 245414 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2736 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6010338.0852 | 2102254.0506 | 37.752972272430206 | -122.40713647446998 | (37.7529722724302, -122.40713647447) | |||
| 22172 | 22172 | 489 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2730 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6010359.8791 | 2102254.6242 | 37.7529750670361 | -122.40706114707301 | (37.7529750670361, -122.407061147073) | |||
| 137830 | 137830 | 245413 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2726 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6010382.82 | 2102257.4918 | 37.7529842245941 | -122.406982014782 | (37.7529842245941, -122.406982014782) | |||
| 18610 | 18610 | 487 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2718 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010403.4669 | 2102258.6388 | 37.7529885293488 | -122.406910694342 | (37.7529885293488, -122.406910694342) | |||
| 18907 | 18907 | 481 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2700 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010503.8335 | 2102264.9476 | 37.753011467555204 | -122.406564050249 | (37.7530114675552, -122.406564050249) | |||
| 44212 | 44212 | 184648 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1691 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5983748.1287 | 2103659.9866 | 37.755308660398505 | -122.49919205978998 | (37.7553086603985, -122.49919205979) | |||
| 43401 | 43401 | 182246 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1455 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5985863.116 | 2105312.6885 | 37.759970370515106 | -122.491999577939 | (37.7599703705151, -122.491999577939) | |||
| 18161 | 18161 | 107661 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1312 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5999086.9 | 2105066.2 | 37.7600576690463 | -122.446247345124 | (37.7600576690463, -122.446247345124) | |||
| 21777 | 21777 | 15445 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2250 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006857.7723 | 2105245.8857 | 37.7609917781074 | -122.419384314212 | (37.7609917781074, -122.419384314212) | |||
| 17778 | 17778 | 15435 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2141 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006881.4762 | 2105834.0306 | 37.7626080219354 | -122.419344056803 | (37.7626080219354, -122.419344056803) | |||
| 894 | 894 | 15433 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2135 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006876.1683 | 2105910.6162 | 37.7628180091578 | -122.419367848279 | (37.7628180091578, -122.419367848279) | |||
| 72332 | 72332 | 182039 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1323 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5988935.747 | 2106319.8798 | 37.7629149697028 | -122.481446720354 | (37.7629149697028, -122.481446720354) | |||
| 55161 | 55161 | 246282 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2125 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6006871.6187 | 2105950.8046 | 37.762928100871896 | -122.41938643496401 | (37.7629281008719, -122.419386434964) | |||
| 157150 | 157150 | 43881 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1245 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 3 | Permit Number 43494 | 5981473.1113 | 2106617.2091 | 37.7632946239394 | -122.507278997702 | (37.7632946239394, -122.507278997702) | ||
| 58145 | 58145 | 183272 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1251 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5983645.262999999 | 2106639.9345 | 37.7634847239936 | -122.49976803825199 | (37.7634847239936, -122.499768038252) | |||
| 171803 | 171803 | 60926 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2000 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/1983 12:00:00 AM | 13 | Permit Number 20727 | 5989507.2134 | 2106536.1763 | 37.7635420716385 | -122.479486064031 | (37.7635420716385, -122.479486064031) | ||
| 126562 | 126562 | 113465 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 20 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | |||
| 40899 | 40899 | 181727 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2755 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5987094.0342 | 2107004.1542 | 37.76468654333279 | -122.487866760897 | (37.7646865433328, -122.487866760897) | |||
| 146420 | 146420 | 245460 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2940 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6007306.1163 | 2106778.6027 | 37.7652255036159 | -122.41794233876101 | (37.7652255036159, -122.417942338761) | |||
| 63246 | 63246 | 245461 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2886 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6007563.8542 | 2106794.7707 | 37.7652843992631 | -122.417052028294 | (37.7652843992631, -122.417052028294) | |||
| 34183 | 34183 | 32298 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1616 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | 12 | Permit Number 36875 | 6011655.3244 | 2107023.9767 | 37.766143058580205 | -122.40291664053001 | (37.7661430585802, -122.40291664053) | |
| 28900 | 28900 | 98468 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6011948.2516 | 2107041.0959 | 37.7662064164751 | -122.40190466033701 | (37.7662064164751, -122.401904660337) | |||
| 48254 | 48254 | 248610 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 872 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997691.4278 | 2107516.4386 | 37.7667056091614 | -122.4512503025 | (37.7667056091614, -122.4512503025) | |||
| 60986 | 60986 | 248611 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 862 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997689.6108 | 2107534.9111 | 37.7667562259025 | -122.45125791953001 | (37.7667562259025, -122.45125791953) | |||
| 154058 | 154058 | 248533 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 174 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998320.7066 | 2107735.9897 | 37.7673444513971 | -122.449089561777 | (37.7673444513971, -122.449089561777) | |||
| 149998 | 149998 | 248465 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 772 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5997147.6982 | 2107925.2578 | 37.767796974534605 | -122.45316047633601 | (37.7677969745346, -122.453160476336) | |||
| 41329 | 41329 | 248473 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 758 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5998609.6056 | 2107900.123 | 37.7678116388378 | -122.448102124294 | (37.7678116388378, -122.448102124294) | |||
| 24010 | 24010 | 248469 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 145 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998248.1791 | 2107933.2828 | 37.7678820197346 | -122.449354639507 | (37.7678820197346, -122.449354639507) | |||
| 183087 | 183087 | 248411 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1737 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5997411.4623 | 2108107.5609 | 37.76831264578671 | -122.45226130839701 | (37.7683126457867, -122.452261308397) | |||
| 150865 | 150865 | 246100 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997118.778 | 2108135.4212 | 37.7683723717283 | -122.453275681682 | (37.7683723717283, -122.453275681682) | |||
| 43725 | 43725 | 246164 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1756 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5997323.9447 | 2108138.6009 | 37.768392859677896 | -122.452566262235 | (37.7683928596779, -122.452566262235) | |||
| 73071 | 73071 | 248407 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 39 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999275.3753 | 2108109.8322 | 37.7684254834855 | -122.445814398115 | (37.7684254834855, -122.445814398115) | |||
| 183850 | 183850 | 248348 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 706 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997944.2901 | 2108144.5061 | 37.7684445974615 | -122.45042098016701 | (37.7684445974615, -122.450420980167) | |||
| 39575 | 39575 | 246153 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1720 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5997461.1263 | 2108156.7707 | 37.7684506082583 | -122.45209307718099 | (37.7684506082583, -122.452093077181) | |||
| 77095 | 77095 | 248383 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1621 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997789.5444 | 2108160.7074 | 37.7684802243505 | -122.450957397559 | (37.7684802243505, -122.450957397559) | |||
| 131399 | 131399 | 248376 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 701 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5997900.3799 | 2108160.4046 | 37.7684857374838 | -122.45057400725 | (37.7684857374838, -122.45057400725) | |||
| 74916 | 74916 | 248371 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1609 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997803.1717 | 2108162.5244 | 37.7684859935016 | -122.45091039318199 | (37.7684859935016, -122.450910393182) | |||
| 172810 | 172810 | 246165 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1700 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5997526.8402 | 2108168.581 | 37.7684868003121 | -122.45186663191299 | (37.7684868003121, -122.451866631913) | |||
| 185767 | 185767 | 248349 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1589 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997958.0688 | 2108183.1168 | 37.7685514011761 | -122.450376104779 | (37.7685514011761, -122.450376104779) | |||
| 38886 | 38886 | 248350 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1587 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997973.5131 | 2108185.8423 | 37.7685597685915 | -122.45032288098899 | (37.7685597685915, -122.450322880989) | |||
| 182156 | 182156 | 246388 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1640 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997718.8338 | 2108194.9271 | 37.768570134567206 | -122.45120444629801 | (37.7685701345672, -122.451204446298) | |||
| 161008 | 161008 | 248352 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1585 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998007.43 | 2108190.3847 | 37.7685741818657 | -122.450205893283 | (37.7685741818657, -122.450205893283) | |||
| 47229 | 47229 | 246151 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1622 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997783.0336 | 2108202.195 | 37.7685937659628 | -122.450982909765 | (37.7685937659628, -122.450982909765) | |||
| 165925 | 165925 | 248346 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1575 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998065.2703 | 2108198.2582 | 37.7685991103156 | -122.45000639696 | (37.7685991103156, -122.45000639696) | |||
| 183117 | 183117 | 246173 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 675 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997888.1153 | 2108243.3798 | 37.768712864196 | -122.45062241217899 | (37.768712864196, -122.450622412179) | |||
| 33304 | 33304 | 248365 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 701 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998521.6337 | 2108231.8723 | 37.7687175089215 | -122.44843030114201 | (37.7687175089215, -122.448430301142) |
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");