trees

294 rows where Police Districts = 4 and qSpecies_id = 53

✎ View and edit SQL

This data as json, CSV (advanced)

Police Districts ✖

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)
4294 117126 Undocumented 4 Ficus nitida :: Laurel Fig 53 766 NOE ST 3 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6003023 2103770 37.7567226205836 -122.432541687014 (37.7567226205836, -122.432541687014) 2 4 5 28862 3
7359 121255 Undocumented 4 Ficus nitida :: Laurel Fig 53 283 Dorland St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003780 2105549 37.7616502297697 -122.430050607682 (37.7616502297697, -122.430050607682) 8 4 5 28862 3
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
8959 113224 Undocumented 4 Ficus nitida :: Laurel Fig 53 4244 23RD ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001623 2102374 37.7528100494278 -122.437283434624 (37.7528100494278, -122.437283434624) 2 4 5 28862 22
10358 120965 Undocumented 4 Ficus nitida :: Laurel Fig 53 1145x Noe St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003243 2101623 37.7508399403415 -122.43162756863 (37.7508399403415, -122.43162756863) 2 4 5 28862 22
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
11498 115743 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X POND ST 1 Sidewalk: Curb side : Cutout Tree Public Library 12 Rec/Park   28 3x3   6003250 2106477 37.764168263012 -122.431949928803 (37.764168263012, -122.431949928803) 15 4 5 28862 3
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
17055 104825 Undocumented 4 Ficus nitida :: Laurel Fig 53 45 Prosper St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003350 2106266 37.7635945765505 -122.431588992909 (37.7635945765505, -122.431588992909) 15 4 5 28862 3
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
24098 50784 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4425@ EUREKA 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/02/2004 12:00:00 AM     Permit Number 47310 6001319.3692016 2105218.84665198 37.760604043869 -122.438537258087 (37.760604043869, -122.438537258087) 2 4 5 28862 3
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
32408 54027 Permitted Site 7 Ficus nitida :: Laurel Fig 53 246 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/01/2016 12:00:00 AM 3 6x6 Permit Number 778679 6004696.3346429 2103995.33974478 37.7574361004301 -122.426770728763 (37.7574361004301, -122.426770728763) 2 4 5 28862 3
32730 5389 Permitted Site 7 Ficus nitida :: Laurel Fig 53 330X Dolores St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 4x4   6004827.24095 2106401.30238 37.7640497043733 -122.426489313449 (37.7640497043733, -122.426489313449) 8 4 5 28859 3
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
43513 120964 Undocumented 4 Ficus nitida :: Laurel Fig 53 1145x Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003243 2101623 37.7508399403415 -122.43162756863 (37.7508399403415, -122.43162756863) 2 4 5 28862 22
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
44231 57108 Permitted Site 7 Ficus nitida :: Laurel Fig 53 280 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1974 12:00:00 AM 24 6x6 Permit Number 14378 6004748.38429029 2102046.50032189 37.7520879863161 -122.426451960244 (37.7520879863161, -122.426451960244) 2 4 5 28862 22
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
51694 173776 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 89 Eureka St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001439 2105287 37.7607979807122 -122.438128392537 (37.7607979807122, -122.438128392537) 15 4 5 28862 3
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
53386 55163 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1328 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/03/1993 12:00:00 AM     Permit Number 31912 6002514.24849197 2101716.89965545 37.751056432833 -122.434154367056 (37.751056432833, -122.434154367056) 2 4 5 28862 22
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
59221 48449 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1971 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/31/2002 12:00:00 AM     Permit Number 45821 6004348.70626507 2107156.39257844 37.7660959373339 -122.428198241647 (37.7660959373339, -122.428198241647) 8 4 5 28862 3
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
60853 97999 Undocumented 4 Ficus nitida :: Laurel Fig 53 30 Eagle St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6000135 2104379 37.7582305885461 -122.442573139957 (37.7582305885461, -122.442573139957) 2 4 5 28862 3
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
61113 57802 Permitted Site 7 Ficus nitida :: Laurel Fig 53 107 Hoffman Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/26/1988 12:00:00 AM 8 3x3 Permit Number 25561 6000622.33928566 2102551.03510935 37.7532392091702 -122.440756591601 (37.7532392091702, -122.440756591601) 2 4 5 28862 22
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
61535 5622 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1202 Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     28 3X3   6005101.96034 2101291.72603 37.7500355321086 -122.425175538874 (37.7500355321086, -122.425175538874) 2 4 5 28862 22
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
63433 4418 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1128 Church St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004420.05713 2102283.99445 37.752721523998 -122.427604283815 (37.752721523998, -122.427604283815) 2 4 5 28862 22
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
64331 5481 Permitted Site 7 Ficus nitida :: Laurel Fig 53 700X Dolores St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     80 6   6004966.5668947 2104283.6095193 37.7582428963987 -122.425856676166 (37.7582428963987, -122.425856676166) 2 4 5 28862 3
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
66076 112051 Undocumented 4 Ficus nitida :: Laurel Fig 53 3748x 22ND ST 1 Sidewalk: Curb side : Cutout Tree Private 2     36 3x3   6003448 2103060 37.7547972209553 -122.431021210073 (37.7547972209553, -122.431021210073) 2 4 5 28862 22
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
69799 59060 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4437 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/28/1992 12:00:00 AM 14 2x2 Permit Number 30882 6000423.21385776 2102243.23045707 37.7523827100743 -122.441423120737 (37.7523827100743, -122.441423120737) 2 4 5 28862 22
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
72782 58078 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4624 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/1977 12:00:00 AM     Permit Number 17049 6000401 2105218 37.7605494356876 -122.441713410467 (37.7605494356876, -122.441713410467) 15 4 5 28862 3
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);