trees
294 rows where Police Districts = 4 and qSpecies_id = 53 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8209 | 103628 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1450X Stevenson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.7687644406503 | -122.421417350008 | (37.7687644406503, -122.421417350008) | 8 | 4 | 7 | 28853 | 19 | ||
8269 | 99967 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2270 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007986.9 | 2105322.2 | 37.7612648499102 | -122.415484545241 | (37.7612648499102, -122.415484545241) | 2 | 4 | 7 | 28859 | 19 | |||||
10859 | 102456 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
16900 | 485 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2706 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6010468.2249 | 2102315.41281 | 37.7531480416193 | -122.406690748371 | (37.7531480416193, -122.406690748371) | 10 | 4 | 7 | 28859 | 19 | |||
18243 | 96948 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 900X Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 6x6 | 6007359.7 | 2102053.2 | 37.7522536530624 | -122.417422091759 | (37.7522536530624, -122.417422091759) | 2 | 4 | 7 | 28859 | 19 | |||
19799 | 661 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3290X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007123.820387 | 2102082.126741 | 37.7523198047665 | -122.418239853186 | (37.7523198047665, -122.418239853186) | 2 | 4 | 7 | 28859 | 19 | |||
20262 | 253597 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 269 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010453 | 2107072 | 37.7662077096315 | -122.407078650031 | (37.7662077096315, -122.407078650031) | 8 | 4 | 8 | 28853 | 19 | ||||
20364 | 516 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2800 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6010023.971 | 2102231.13329 | 37.7528917628192 | -122.408221130018 | (37.7528917628192, -122.408221130018) | 2 | 4 | 7 | 28859 | 19 | |||
20430 | 647 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3244X 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.7523806444342 | -122.417257199664 | (37.7523806444342, -122.417257199664) | 2 | 4 | 7 | 28859 | 19 | |||
21359 | 87146 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2405 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50131 | 6008226 | 2104427 | 37.7588202724984 | -122.414594246502 | (37.7588202724984, -122.414594246502) | 2 | 4 | 7 | 28859 | 19 | ||
21841 | 111225 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
23368 | 512 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2790 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6010086.59475 | 2102267.66488 | 37.7529955768562 | -122.408007140426 | (37.7529955768562, -122.408007140426) | 2 | 4 | 7 | 28859 | 19 | |||
24151 | 96336 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1851 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005204.9 | 2107156.8 | 37.7661454629436 | -122.42523686393 | (37.7661454629436, -122.42523686393) | 8 | 4 | 5 | 28853 | 19 | |||
24579 | 96732 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 514 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3.5 | 6007319.4 | 2106562.9 | 37.7646339820142 | -122.417881101898 | (37.7646339820142, -122.417881101898) | 8 | 4 | 7 | 28859 | 19 | |||
24869 | 18469 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 4X4 | 6010532.643 | 2102160.24981 | 37.7527256023187 | -122.406457044136 | (37.7527256023187, -122.406457044136) | 10 | 4 | 7 | 28859 | 19 | |||
26891 | 601 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3085 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6008510.8606794 | 2102109.8045166 | 37.7524737788751 | -122.413445186335 | (37.7524737788751, -122.413445186335) | 2 | 4 | 7 | 28859 | 19 | ||||
28577 | 18320 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 206 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4X4 | 6010262.2750436 | 2107350.6845554 | 37.7669622387245 | -122.40775798639 | (37.7669622387245, -122.40775798639) | 8 | 4 | 8 | 28853 | 19 | |||
29857 | 57300 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3178 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1976 12:00:00 AM | 14 | 3x3 | Permit Number 16122 | 6005671.4432239 | 2106688.52693537 | 37.7648860421109 | -122.423589884437 | (37.7648860421109, -122.423589884437) | 8 | 4 | 5 | 28853 | 19 | |
29987 | 578 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3024 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6008810.60715 | 2102251.62423 | 37.7528800095792 | -122.412418632597 | (37.7528800095792, -122.412418632597) | 2 | 4 | 7 | 28859 | 19 | |||
31123 | 18463 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1185X Potrero Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 6010590.6142382 | 2102338.4990144 | 37.7532182781408 | -122.406269126047 | (37.7532182781408, -122.406269126047) | 10 | 4 | 8 | 28859 | 19 | |||
32305 | 173934 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 614 Alabama St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9x9 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.412119658359 | (37.7614283394777, -122.412119658359) | 2 | 4 | 7 | 28859 | 19 | ||||
33185 | 18322 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 226 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4X4 | 6010268.7839855 | 2107259.8540962 | 37.7667132034185 | -122.407729067657 | (37.7667132034185, -122.407729067657) | 8 | 4 | 8 | 28853 | 19 | |||
33912 | 484 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2704 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010466.15731 | 2102352.85565 | 37.7532507356841 | -122.406700537042 | (37.7532507356841, -122.406700537042) | 10 | 4 | 7 | 28859 | 19 | |||
34217 | 575 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3007 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6008864.65035 | 2102095.7164 | 37.7524549543286 | -122.41222072227 | (37.7524549543286, -122.41222072227) | 2 | 4 | 7 | 28859 | 19 | |||
35179 | 95222 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 299 on 16th St Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004880 | 2106610 | 37.7646257206218 | -122.426321695151 | (37.7646257206218, -122.426321695151) | 8 | 4 | 5 | 28859 | 19 | |||
37666 | 646 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3244X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.7523806444342 | -122.417257199664 | (37.7523806444342, -122.417257199664) | 2 | 4 | 7 | 28859 | 19 | |||
40407 | 668 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3297X 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6007079.62061 | 2102029.84762 | 37.7521737701718 | -122.418388996947 | (37.7521737701718, -122.418388996947) | 2 | 4 | 7 | 28859 | 19 | |||
41221 | 96947 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 900X Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 6x6 | 6007389 | 2101516 | 37.750780272338 | -122.417282702809 | (37.750780272338, -122.417282702809) | 2 | 4 | 7 | 28859 | 19 | |||
43227 | 110731 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3515 25TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006381 | 2101411 | 37.7504352040325 | -122.420761009138 | (37.7504352040325, -122.420761009138) | 2 | 4 | 5 | 28859 | 19 | ||||
43367 | 116602 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3260x 16TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 9x9 | 6005124 | 2106632 | 37.764699916645 | -122.425479329399 | (37.764699916645, -122.425479329399) | 8 | 4 | 5 | 28859 | 19 | |||
43818 | 24454 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1384 Valencia St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6006362.58284 | 2101545.07315 | 37.7508023001764 | -122.420834214589 | (37.7508023001764, -122.420834214589) | 2 | 4 | 5 | 28859 | 19 | |||
43945 | 573 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2990 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | Permit Number 776380 | 6009007.86528 | 2102243.77418 | 37.7528695228517 | -122.411735919997 | (37.7528695228517, -122.411735919997) | 2 | 4 | 7 | 28859 | 19 | ||
44100 | 115215 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3395x 21ST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2016 12:00:00 AM | 3 | 9x5 | Permit Number 779049 | 6005778 | 2103691 | 37.7566615513452 | -122.423008263345 | (37.7566615513452, -122.423008263345) | 2 | 4 | 5 | 28859 | 19 | |
44451 | 96734 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 520 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3.5 | 6007401.6 | 2106571.6 | 37.7646624959011 | -122.417597409955 | (37.7646624959011, -122.417597409955) | 8 | 4 | 7 | 28859 | 19 | |||
44509 | 60715 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 30 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1983 12:00:00 AM | 24 | 3x3 | Permit Number 20368 | 6005215.9296478 | 2105282.4178358 | 37.7609994776864 | -122.425065336381 | (37.7609994776864, -122.425065336381) | 2 | 4 | 5 | 28859 | 19 | |
44695 | 525 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2829 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009855.90033 | 2102163.70478 | 37.7526972066188 | -122.408797595672 | (37.7526972066188, -122.408797595672) | 2 | 4 | 7 | 28859 | 19 | |||
47161 | 18304 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 100 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010232.4387225 | 2107842.1672579 | 37.7683100673499 | -122.407895847634 | (37.7683100673499, -122.407895847634) | 8 | 4 | 8 | 28853 | 19 | |||
47426 | 693 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1299X Potrero Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x3 | 6010664.7611959 | 2101498.8811325 | 37.7509170198962 | -122.405953567035 | (37.7509170198962, -122.405953567035) | 10 | 4 | 8 | 28859 | 19 | |||
48272 | 95217 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 135 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6005910 | 2106464 | 37.7642830068396 | -122.422748818687 | (37.7642830068396, -122.422748818687) | 8 | 4 | 5 | 28859 | 19 | |||
50489 | 18364 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 598 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6010361.2141646 | 2105516.7578044 | 37.7619322307219 | -122.407286474232 | (37.7619322307219, -122.407286474232) | 8 | 4 | 8 | 28859 | 19 | |||
51092 | 109603 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 602 SHOTWELL ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007851.6 | 2104381.9 | 37.758675396701 | -122.415885905109 | (37.758675396701, -122.415885905109) | 2 | 4 | 7 | 28859 | 19 | ||||
51820 | 12942 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 725X Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 6 | 6005046.7981655 | 2104134.69405 | 37.7578385432445 | -122.425568603003 | (37.7578385432445, -122.425568603003) | 2 | 4 | 5 | 28859 | 19 | |||
51840 | 15324 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1698X Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006725.5802 | 2108585.93757 | 37.7701553284346 | -122.420078550817 | (37.7701553284346, -122.420078550817) | 8 | 4 | 9 | 28853 | 19 | |||
51940 | 665 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3297X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6007079.62061 | 2102029.84762 | 37.7521737701718 | -122.418388996947 | (37.7521737701718, -122.418388996947) | 2 | 4 | 7 | 28859 | 19 | |||
53498 | 24453 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1384 Valencia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6006362.58284 | 2101545.07315 | 37.7508023001764 | -122.420834214589 | (37.7508023001764, -122.420834214589) | 2 | 4 | 5 | 28859 | 19 | |||
53550 | 18383 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 804 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3x3 | 6010399.792436 | 2104541.9824298 | 37.7592578761131 | -122.407084334673 | (37.7592578761131, -122.407084334673) | 10 | 4 | 7 | 28859 | 19 | |||
54160 | 110730 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3515 25TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006381 | 2101411 | 37.7504352040325 | -122.420761009138 | (37.7504352040325, -122.420761009138) | 2 | 4 | 5 | 28859 | 19 | ||||
55414 | 61158 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3347 20TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1983 12:00:00 AM | 12 | 5x5 | Permit Number 21016 | 6007930.5 | 2104397.2 | 37.758721842404 | -122.415614115387 | (37.758721842404, -122.415614115387) | 2 | 4 | 7 | 28859 | 19 |
56222 | 121122 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2701X 24th St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6010429 | 2102109 | 37.7525790830309 | -122.406811850318 | (37.7525790830309, -122.406811850318) | 10 | 4 | 7 | 28859 | 19 | ||||
56413 | 111223 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
56472 | 96337 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1851 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005204.9 | 2107156.8 | 37.7661454629436 | -122.42523686393 | (37.7661454629436, -122.42523686393) | 8 | 4 | 5 | 28853 | 19 | |||
57818 | 111388 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 298x CLINTON PARK | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004911 | 2108307 | 37.7692870280045 | -122.426335307428 | (37.7692870280045, -122.426335307428) | 8 | 4 | 5 | 28862 | 19 | |||
58653 | 24451 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1384 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6006362.58284 | 2101545.07315 | 37.7508023001764 | -122.420834214589 | (37.7508023001764, -122.420834214589) | 2 | 4 | 5 | 28859 | 19 | |||
58860 | 111391 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 298x CLINTON PARK | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004911 | 2108307 | 37.7692870280045 | -122.426335307428 | (37.7692870280045, -122.426335307428) | 8 | 4 | 5 | 28862 | 19 | ||||
59584 | 18467 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1185X Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6010590.6142382 | 2102338.4990144 | 37.7532182781408 | -122.406269126047 | (37.7532182781408, -122.406269126047) | 10 | 4 | 8 | 28859 | 19 | |||
60087 | 86905 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 36 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2007 12:00:00 AM | 3x3 | Permit Number 49869 | 6005775 | 2106383 | 37.7640529822515 | -122.423209987967 | (37.7640529822515, -122.423209987967) | 8 | 4 | 5 | 28859 | 19 | ||
60410 | 111206 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3100x 19TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008781 | 2105093 | 37.7606801217813 | -122.412721875792 | (37.7606801217813, -122.412721875792) | 2 | 4 | 7 | 28859 | 19 | |||
61037 | 111219 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
61233 | 28383 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 286 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6006047.68288 | 2107930.23885 | 37.7683167183705 | -122.422376798825 | (37.7683167183705, -122.422376798825) | 8 | 4 | 5 | 28853 | 19 | ||||
62161 | 109596 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3332 21ST ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6006085.3 | 2103802.1 | 37.7569839418566 | -122.421953398845 | (37.7569839418566, -122.421953398845) | 2 | 4 | 5 | 28859 | 19 | |||
62309 | 111394 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 298x CLINTON PARK | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004911 | 2108307 | 37.7692870280045 | -122.426335307428 | (37.7692870280045, -122.426335307428) | 8 | 4 | 5 | 28862 | 19 | ||||
63970 | 111213 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3100x 19TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008781 | 2105093 | 37.7606801217813 | -122.412721875792 | (37.7606801217813, -122.412721875792) | 2 | 4 | 7 | 28859 | 19 | |||
64233 | 121118 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2701X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010429 | 2102109 | 37.7525790830309 | -122.406811850318 | (37.7525790830309, -122.406811850318) | 10 | 4 | 7 | 28859 | 19 | ||||
64312 | 111215 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3100x 19TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008781 | 2105093 | 37.7606801217813 | -122.412721875792 | (37.7606801217813, -122.412721875792) | 2 | 4 | 7 | 28859 | 19 | |||
64711 | 488 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2728 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6010357.12636 | 2102291.83707 | 37.7530770912847 | -122.407073289419 | (37.7530770912847, -122.407073289419) | 10 | 4 | 7 | 28859 | 19 | |||
64858 | 102457 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
66172 | 18444 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1020 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4x4 | 6010472.2950908 | 2103284.5044843 | 37.7558091798762 | -122.406744963711 | (37.7558091798762, -122.406744963711) | 10 | 4 | 7 | 28859 | 19 | |||
70053 | 15430 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2125 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006871.65728 | 2105982.3734 | 37.7630147835921 | -122.419388541195 | (37.7630147835921, -122.419388541195) | 8 | 4 | 7 | 28859 | 19 | |||
70728 | 504 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2763 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6010225.39225 | 2102202.2647 | 37.7528237725585 | -122.407522539236 | (37.7528237725585, -122.407522539236) | 2 | 4 | 7 | 28859 | 19 | |||
71888 | 102035 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2400 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 5x5 | 6008197 | 2104472 | 37.7589422028837 | -122.414697726814 | (37.7589422028837, -122.414697726814) | 2 | 4 | 7 | 28859 | 19 | |||
71942 | 50566 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2295 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | |||
72643 | 24452 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1384 Valencia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6006362.58284 | 2101545.07315 | 37.7508023001764 | -122.420834214589 | (37.7508023001764, -122.420834214589) | 2 | 4 | 5 | 28859 | 19 | |||
72828 | 18316 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 199 POTRERO AVE | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6010430 | 2107503 | 37.7673898501442 | -122.407188587519 | (37.7673898501442, -122.407188587519) | 8 | 4 | 8 | 28853 | 19 | |||
73104 | 5386 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 325X Dolores St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6004919.4864142 | 2106495.5645768 | 37.7643137401636 | -122.426176974515 | (37.7643137401636, -122.426176974515) | 8 | 4 | 5 | 28859 | 19 | |||
73677 | 18366 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 601 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6010418.5901612 | 2105518.9759028 | 37.7619415321313 | -122.407088188566 | (37.7619415321313, -122.407088188566) | 8 | 4 | 8 | 28859 | 19 | |||
75232 | 18306 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 100 Potrero Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010232.4387225 | 2107842.1672579 | 37.7683100673499 | -122.407895847634 | (37.7683100673499, -122.407895847634) | 8 | 4 | 8 | 28853 | 19 | |||
76742 | 594 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3056 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6008579.28838 | 2102218.52685 | 37.7527761477761 | -122.413216238549 | (37.7527761477761, -122.413216238549) | 2 | 4 | 7 | 28859 | 19 | |||
77226 | 121119 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2701X 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010429 | 2102109 | 37.7525790830309 | -122.406811850318 | (37.7525790830309, -122.406811850318) | 10 | 4 | 7 | 28859 | 19 | ||||
78273 | 45427 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 614 Alabama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2001 12:00:00 AM | 9x9 | Permit Number 44218 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.412119658359 | (37.7614283394777, -122.412119658359) | 2 | 4 | 7 | 28859 | 19 | ||
78654 | 96735 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 520 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3.5 | 6007401.6 | 2106571.6 | 37.7646624959011 | -122.417597409955 | (37.7646624959011, -122.417597409955) | 8 | 4 | 7 | 28859 | 19 | |||
79861 | 649 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3244X 24th St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6007408.30918 | 2102098.45375 | 37.7523806444342 | -122.417257199664 | (37.7523806444342, -122.417257199664) | 2 | 4 | 7 | 28859 | 19 | |||
79982 | 628 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3166 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3x3 | 6007874.17365 | 2102144.23632 | 37.7525325514911 | -122.41564940087 | (37.7525325514911, -122.41564940087) | 2 | 4 | 7 | 28859 | 19 | |||
79996 | 96733 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 514 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3.5 | 6007319.4 | 2106562.9 | 37.7646339820142 | -122.417881101898 | (37.7646339820142, -122.417881101898) | 8 | 4 | 7 | 28859 | 19 | |||
80355 | 588 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3044 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008688.10488 | 2102161.42262 | 37.7526254609089 | -122.412835893087 | (37.7526254609089, -122.412835893087) | 2 | 4 | 7 | 28859 | 19 | |||
80775 | 15434 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2137 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006871.30054 | 2105936.92899 | 37.7628899837695 | -122.419386550959 | (37.7628899837695, -122.419386550959) | 8 | 4 | 7 | 28859 | 19 | |||
81588 | 113833 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 932 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 6007966 | 2102301 | 37.7529681504442 | -122.415342945464 | (37.7529681504442, -122.415342945464) | 2 | 4 | 7 | 28859 | 19 | ||||
83519 | 57298 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3120 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1976 12:00:00 AM | 20 | 5x5 | Permit Number 16120 | 6006015.66145192 | 2106707.62529636 | 37.7649579052871 | -122.422400676647 | (37.7649579052871, -122.422400676647) | 8 | 4 | 5 | 28853 | 19 | |
83526 | 694 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1299X Potrero Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x3 | 6010664.7611959 | 2101498.8811325 | 37.7509170198962 | -122.405953567035 | (37.7509170198962, -122.405953567035) | 10 | 4 | 8 | 28859 | 19 | |||
85308 | 631 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3195 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6007841.79281 | 2102038.51474 | 37.7522404437102 | -122.415753894425 | (37.7522404437102, -122.415753894425) | 2 | 4 | 7 | 28859 | 19 | |||
86183 | 645 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3244X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.7523806444342 | -122.417257199664 | (37.7523806444342, -122.417257199664) | 2 | 4 | 7 | 28859 | 19 | |||
86618 | 111873 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 300X POTRERO AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010207 | 2106863 | 37.7656200738156 | -122.407914780785 | (37.7656200738156, -122.407914780785) | 8 | 4 | 8 | 28853 | 19 | ||||
86959 | 111872 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 300X POTRERO AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010207 | 2106863 | 37.7656200738156 | -122.407914780785 | (37.7656200738156, -122.407914780785) | 8 | 4 | 8 | 28853 | 19 | ||||
89072 | 18459 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1137 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6010601.42584 | 2102531.48836 | 37.7537487889396 | -122.406245333375 | (37.7537487889396, -122.406245333375) | 10 | 4 | 8 | 28859 | 19 | |||
89256 | 111871 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 300X POTRERO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010207 | 2106863 | 37.7656200738156 | -122.407914780785 | (37.7656200738156, -122.407914780785) | 8 | 4 | 8 | 28853 | 19 | ||||
89426 | 65007 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1849 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/1989 12:00:00 AM | 18 | 3x3 | Permit Number 26048 | 6008683.18209706 | 2107760.52572873 | 37.7679990416006 | -122.413248823154 | (37.7679990416006, -122.413248823154) | 8 | 4 | 7 | 28853 | 19 | |
90532 | 490 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2734 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010357.12636 | 2102291.83707 | 37.7530770912847 | -122.407073289419 | (37.7530770912847, -122.407073289419) | 10 | 4 | 7 | 28859 | 19 | |||
90722 | 56236 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 147 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/1973 12:00:00 AM | 24 | Permit Number 12362 | 6006719.97734959 | 2102927.77810186 | 37.7546190293471 | -122.419696406291 | (37.7546190293471, -122.419696406291) | 2 | 4 | 7 | 28859 | 19 | ||
90745 | 18351 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 469 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 6010382.7073264 | 2106125.7302845 | 37.7636055342277 | -122.407255067708 | (37.7636055342277, -122.407255067708) | 8 | 4 | 8 | 28859 | 19 | |||
91776 | 18465 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1176 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/05/2015 12:00:00 AM | 45 | 3X4 | 6010529.14326 | 2102401.59944 | 37.7533880992141 | -122.40648615219 | (37.7533880992141, -122.40648615219) | 10 | 4 | 7 | 28859 | 19 | ||
92126 | 103631 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1450X Stevenson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.7687644406503 | -122.421417350008 | (37.7687644406503, -122.421417350008) | 8 | 4 | 7 | 28853 | 19 |
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) );