trees

114 rows where Police Districts = 4 and qSpecies_id = 91

✎ 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)
3509 99817 Undocumented 4 Schinus molle :: California Pepper 91 1134 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2       7x6   6002486 2102282 37.7526064609065 -122.434292449268 (37.7526064609065, -122.434292449268) 2 4 5 28862 22
9411 33144 Permitted Site 7 Schinus molle :: California Pepper 91 4238 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37370 6001375.34520428 2103384.04824408 37.7555693169237 -122.438212219782 (37.7555693169237, -122.438212219782) 2 4 5 28862 3
10299 239628 DPW Maintained 1 Schinus molle :: California Pepper 91 872 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6003717.59485 2103189.68577 37.7551685799882 -122.430098127942 (37.7551685799882, -122.430098127942) 2 4 5 28862 22
11330 166753 Planning Code 138.1 required 2 Schinus molle :: California Pepper 91 350 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/26/2019 12:00:00 AM 3 4x4 Permit Number 781737 6002856.72425 2101550.76622 37.7506197011549 -122.43295818429 (37.7506197011549, -122.43295818429) 2 4 5 28862 22
12994 239597 DPW Maintained 1 Schinus molle :: California Pepper 91 1287 Noe St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 6ft   6003266.18046 2100734.45358 37.7484015143127 -122.431483983218 (37.7484015143127, -122.431483983218) 2 4 5 28862 22
13603 239638 DPW Maintained 1 Schinus molle :: California Pepper 91 3689 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6003857.31467 2103604.80906 37.7563163226577 -122.429644541356 (37.7563163226577, -122.429644541356) 2 4 5 28862 22
15530 239630 DPW Maintained 1 Schinus molle :: California Pepper 91 431 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2     37 Width 3ft   6003562.89343 2102710.70444 37.7538446475336 -122.430598954102 (37.7538446475336, -122.430598954102) 2 4 5 28862 22
16131 55409 Permitted Site 7 Schinus molle :: California Pepper 91 872 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/27/1987 12:00:00 AM     Permit Number 11349 6003719.33886967 2103195.40450941 37.7551843810696 -122.430092504551 (37.7551843810696, -122.430092504551) 2 4 5 28862 22
17171 239598 DPW Maintained 1 Schinus molle :: California Pepper 91 1287 Noe St 4 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 6ft   6003265.33612 2100745.73511 37.7484324428976 -122.431487708187 (37.7484324428976, -122.431487708187) 2 4 5 28862 22
20090 104219 Permitted Site 7 Schinus molle :: California Pepper 91 642-652 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002365 2104465 37.7585935873912 -122.434866988999 (37.7585935873912, -122.434866988999) 2 4 5 28862 3
23040 239637 DPW Maintained 1 Schinus molle :: California Pepper 91 3691 21st St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003808.38299 2103603.27195 37.7563093313217 -122.429813654389 (37.7563093313217, -122.429813654389) 2 4 5 28862 22
23225 239627 DPW Maintained 1 Schinus molle :: California Pepper 91 3885 21st St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6002571.81479 2103540.6818 37.7560673714328 -122.434085656222 (37.7560673714328, -122.434085656222) 2 4 5 28862 22
33437 239641 DPW Maintained 1 Schinus molle :: California Pepper 91 3637 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6004113.74882 2103625.61972 37.7563879806327 -122.428759186701 (37.7563879806327, -122.428759186701) 2 4 5 28862 22
33717 99818 Undocumented 4 Schinus molle :: California Pepper 91 1134 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6002486 2102282 37.7526064609065 -122.434292449268 (37.7526064609065, -122.434292449268) 2 4 5 28862 22
33743 5505 DPW Maintained 1 Schinus molle :: California Pepper 91 785 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 6X8   6005062.26258 2103781.17825 37.756868745618 -122.425489962193 (37.756868745618, -122.425489962193) 2 4 5 28859 19
35105 46070 Permitted Site 7 Schinus molle :: California Pepper 91 3746 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2001 12:00:00 AM     Permit Number 44454 6003440.19743527 2103634.04731282 37.7563729765603 -122.431089163341 (37.7563729765603, -122.431089163341) 2 4 5 28862 3
35161 239594 DPW Maintained 1 Schinus molle :: California Pepper 91 636 Douglass St 2 Sidewalk: Curb side : Yard Tree Private 2     10 Width 4ft   6001191.4238 2102669.11785 37.7535958285084 -122.43879704705 (37.7535958285084, -122.43879704705) 2 4 5 28862 22
36387 251333 DPW Maintained 1 Schinus molle :: California Pepper 91 1245 South Van Ness Ave 7 Sidewalk: Curb side : Cutout Tree Private 2   05/08/2017 12:00:00 AM 3 3x3 Permit Number 779528 6007705.96721 2102462.31706 37.7533964721949 -122.416253615419 (37.7533964721949, -122.416253615419) 2 4 7 28859 19
39126 52643 Permitted Site 7 Schinus molle :: California Pepper 91 4264REVISED 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/2006 12:00:00 AM     Permit Number 48726 6000793.82011207 2102903.5552845 37.7542169085305 -122.440188854974 (37.7542169085305, -122.440188854974) 2 4 5 28862 22
40104 156622 DPW Maintained 1 Schinus molle :: California Pepper 91 1245 South Van Ness Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   05/08/2017 12:00:00 AM 3 3x3 Permit Number 779528 6007708.67537 2102405.47581 37.7532405513196 -122.416240224501 (37.7532405513196, -122.416240224501) 2 4 7 28859 19
41914 62527 Permitted Site 7 Schinus molle :: California Pepper 91 4255 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/15/1986 12:00:00 AM     Permit Number 22709 6000857.54483189 2102854.89709726 37.7540869327376 -122.439964990906 (37.7540869327376, -122.439964990906) 2 4 5 28862 22
47659 53355 Permitted Site 7 Schinus molle :: California Pepper 91 4131 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/12/1969 12:00:00 AM     Permit Number 6248 6002301.07087845 2102348.37639489 37.752778216412 -122.434936712045 (37.752778216412, -122.434936712045) 2 4 5 28862 22
47789 59597 Permitted Site 7 Schinus molle :: California Pepper 91 636 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/25/1981 12:00:00 AM   6x25 Permit Number 18994 6001186.92515468 2102684.94576678 37.7536390322156 -122.438813738462 (37.7536390322156, -122.438813738462) 2 4 5 28862 22
47859 239656 DPW Maintained 1 Schinus molle :: California Pepper 91 701 Church St 39 Front Yard : Yard Tree Private 2     7 Width 3ft   6004336.93411 2104791.99581 37.759603202641 -122.428070449907 (37.759603202641, -122.428070449907) 2 4 5 28862 3
51524 239649 DPW Maintained 1 Schinus molle :: California Pepper 91 3616 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6004202.79012 2103671.51063 37.7565190253373 -122.428454521557 (37.7565190253373, -122.428454521557) 2 4 5 28862 3
54324 239588 DPW Maintained 1 Schinus molle :: California Pepper 91 1245 South Van Ness Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6007705.96721 2102462.31706 37.7533964721949 -122.416253615419 (37.7533964721949, -122.416253615419) 2 4 7 28859 19
58803 239578 DPW Maintained 1 Schinus molle :: California Pepper 91 4092 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 5ft   6003302.87663 2100696.16376 37.7482984592023 -122.431354355844 (37.7482984592023, -122.431354355844) 2 4 5 28862 22
60508 239566 DPW Maintained 1 Schinus molle :: California Pepper 91 3441 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6006878.39898 2100850.62787 37.748924571708 -122.419001222341 (37.748924571708, -122.419001222341) 2 4 7 28859 19
62623 239602 DPW Maintained 1 Schinus molle :: California Pepper 91 890 Castro St 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 4ft   6002438.31508 2103064.33818 37.7547518683248 -122.434513284763 (37.7547518683248, -122.434513284763) 2 4 5 28862 22
63400 242003 DPW Maintained 1 Schinus molle :: California Pepper 91 920 Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/08/2017 12:00:00 AM 3 3x3 Permit Number 779528 6007974.01021 2102435.99237 37.7533392591026 -122.415324800104 (37.7533392591026, -122.415324800104) 2 4 7 28859 19
63611 62514 Permitted Site 7 Schinus molle :: California Pepper 91 4221 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/15/1986 12:00:00 AM     Permit Number 22694 6001435.41662208 2103337.91403702 37.7554460598899 -122.438001170091 (37.7554460598899, -122.438001170091) 2 4 5 28862 22
63916 239643 DPW Maintained 1 Schinus molle :: California Pepper 91 37 Ford St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6003364.63638 2105630.60252 37.7618507577208 -122.431493007021 (37.7618507577208, -122.431493007021) 15 4 5 28862 3
67293 62515 Permitted Site 7 Schinus molle :: California Pepper 91 4229 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/15/1986 12:00:00 AM     Permit Number 22695 6001411.06683037 2103335.42666413 37.7554378453979 -122.43808520078 (37.7554378453979, -122.43808520078) 2 4 5 28862 22
70122 239595 DPW Maintained 1 Schinus molle :: California Pepper 91 4131 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6002300.0276 2102351.40526 37.7527864737179 -122.434940536483 (37.7527864737179, -122.434940536483) 2 4 5 28862 22
70184 50941 Permitted Site 7 Schinus molle :: California Pepper 91 871 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/17/2004 12:00:00 AM     Permit Number 47603 6003770.24487259 2103216.54935313 37.7552453228177 -122.429917964884 (37.7552453228177, -122.429917964884) 2 4 5 28862 22
71031 239642 DPW Maintained 1 Schinus molle :: California Pepper 91 37 Ford St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6003350.6343 2105630.89155 37.7618507577148 -122.431541455278 (37.7618507577148, -122.431541455278) 15 4 5 28862 3
77030 239621 DPW Maintained 1 Schinus molle :: California Pepper 91 489 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     37 Width 3ft   6001854.41167 2103000.82295 37.7545443074853 -122.436528033262 (37.7545443074853, -122.436528033262) 2 4 5 28862 22
78868 239576 DPW Maintained 1 Schinus molle :: California Pepper 91 3971 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6004073.25036 2100697.787 37.7483465459652 -122.428690539642 (37.7483465459652, -122.428690539642) 2 4 5 63 22
79145 62516 Permitted Site 7 Schinus molle :: California Pepper 91 4239 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/15/1986 12:00:00 AM   3x3 Permit Number 52133 6001380.62959357 2103332.31744832 37.7554275771996 -122.438190239105 (37.7554275771996, -122.438190239105) 2 4 5 28862 22
81055 239662 DPW Maintained 1 Schinus molle :: California Pepper 91 1128 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6002485.47315 2102221.41113 37.7524400683713 -122.434289939928 (37.7524400683713, -122.434289939928) 2 4 5 28862 22
81568 239652 DPW Maintained 1 Schinus molle :: California Pepper 91 759 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6002456.72459 2103769.12094 37.7566880780974 -122.434500008993 (37.7566880780974, -122.434500008993) 2 4 5 28862 3
82754 239645 DPW Maintained 1 Schinus molle :: California Pepper 91 4 Ford St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6003486.01122 2105681.39131 37.7619970900117 -122.431076844836 (37.7619970900117, -122.431076844836) 15 4 5 28862 3
83160 239664 DPW Maintained 1 Schinus molle :: California Pepper 91 1140 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 5ft   6002488.98028 2102184.88968 37.7523399882133 -122.434275200945 (37.7523399882133, -122.434275200945) 2 4 5 28862 22
83952 109126 Private 9 Schinus molle :: California Pepper 91 890x CASTRO ST 2 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6002411 2103002 37.7545791519678 -122.434603290485 (37.7545791519678, -122.434603290485) 2 4 5 28862 22
85704 239634 DPW Maintained 1 Schinus molle :: California Pepper 91 871 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6003772.61458 2103201.71767 37.7552047327212 -122.429908711835 (37.7552047327212, -122.429908711835) 2 4 5 28862 22
89326 239635 DPW Maintained 1 Schinus molle :: California Pepper 91 3691 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6003778.26076 2103599.43748 37.7562970969591 -122.429917553956 (37.7562970969591, -122.429917553956) 2 4 5 28862 22
89962 239567 DPW Maintained 1 Schinus molle :: California Pepper 91 3435 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 5ft   6006895.64188 2100851.73373 37.7489285791008 -122.418941674643 (37.7489285791008, -122.418941674643) 2 4 7 28859 19
90678 112684 Undocumented 4 Schinus molle :: California Pepper 91 86 STANTON ST 1 Front Yard : Yard Tree Private 2       3x3   6000281 2103909 37.7569484049338 -122.442034474193 (37.7569484049338, -122.442034474193) 2 4 5 28862 38
93453 53873 Permitted Site 7 Schinus molle :: California Pepper 91 3669 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1987 12:00:00 AM     Permit Number 24724 6003927.57680575 2103608.86941248 37.7563314496504 -122.429401840118 (37.7563314496504, -122.429401840118) 2 4 5 28862 22
94142 46335 Permitted Site 7 Schinus molle :: California Pepper 91 3441 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2002 12:00:00 AM     Permit Number 44585 6006853.77058428 2100846.52070985 37.7489119074947 -122.419086096292 (37.7489119074947, -122.419086096292) 2 4 7 28859 19
94390 100751 Undocumented 4 Schinus molle :: California Pepper 91 767 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6002451 2103738 37.7566023024977 -122.434517581577 (37.7566023024977, -122.434517581577) 2 4 5 28862 3
96303 110276 Permitted Site 7 Schinus molle :: California Pepper 91 3364 25TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   05/15/2015 12:00:00 AM 3 5x5 Permit Number 775124 6007285 2101529 37.7508101157283 -122.417643266234 (37.7508101157283, -122.417643266234) 2 4 7 28859 19
96475 63982 Permitted Site 7 Schinus molle :: California Pepper 91 744 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/1987 12:00:00 AM     Permit Number 24725 6004289.96903589 2104522.67899109 37.7588610652906 -122.428213684799 (37.7588610652906, -122.428213684799) 2 4 5 28862 3
98337 239657 DPW Maintained 1 Schinus molle :: California Pepper 91 671 Church St 4 Front Yard : Yard Tree Private 2     5 Width 3ft   6004329.6886 2104859.6882 37.7597886599416 -122.428100332557 (37.7597886599416, -122.428100332557) 2 4 5 28862 3
98626 104776 Undocumented 4 Schinus molle :: California Pepper 91 767 CASTRO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3x3   6002481.8 2103753.5 37.7566466101352 -122.434412172394 (37.7566466101352, -122.434412172394) 2 4 5 28862 3
99960 239625 DPW Maintained 1 Schinus molle :: California Pepper 91 811 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6002472.06672 2103464.35538 37.7558521357906 -122.434425161094 (37.7558521357906, -122.434425161094) 2 4 5 28862 22
100553 100750 Undocumented 4 Schinus molle :: California Pepper 91 757 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6002448 2103795 37.7567586405263 -122.434532032094 (37.7567586405263, -122.434532032094) 2 4 5 28862 3
103494 239624 DPW Maintained 1 Schinus molle :: California Pepper 91 817 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6002470.85858 2103435.32507 37.7557723569304 -122.434427263721 (37.7557723569304, -122.434427263721) 2 4 5 28862 22
103771 62518 Permitted Site 7 Schinus molle :: California Pepper 91 4367 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/15/1986 12:00:00 AM     Permit Number 22700 6000826.50003313 2103245.32733573 37.7551571922749 -122.440100345908 (37.7551571922749, -122.440100345908) 2 4 5 28862 22
104997 245452 DPW Maintained 1 Schinus molle :: California Pepper 91 2700 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6008618.5823 2106848.9813 37.7654925250272 -122.413407794567 (37.7654925250272, -122.413407794567) 8 4 7 28853 19
105314 239626 DPW Maintained 1 Schinus molle :: California Pepper 91 3885 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6002499.39714 2103536.73091 37.7560524130043 -122.434335817949 (37.7560524130043, -122.434335817949) 2 4 5 28862 22
108016 239647 DPW Maintained 1 Schinus molle :: California Pepper 91 211 Cumberland St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6004225.35965 2104505.85925 37.7588112263749 -122.428435935269 (37.7588112263749, -122.428435935269) 2 4 5 28862 3
112280 239644 DPW Maintained 1 Schinus molle :: California Pepper 91 4 Ford St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6003494.59862 2105679.78343 37.7619931617634 -122.431047029612 (37.7619931617634, -122.431047029612) 15 4 5 28862 3
112295 63956 Permitted Site 7 Schinus molle :: California Pepper 91 4232 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/31/1992 12:00:00 AM       6002352.24062254 2101234.22323777 37.7497219215876 -122.434680095003 (37.7497219215876, -122.434680095003) 2 4 5 28862 22
114058 239648 DPW Maintained 1 Schinus molle :: California Pepper 91 211 Cumberland St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6004246.22251 2104509.47954 37.7588223473949 -122.42836403987 (37.7588223473949, -122.42836403987) 2 4 5 28862 3
114455 239593 DPW Maintained 1 Schinus molle :: California Pepper 91 636 Douglass St 1 Sidewalk: Curb side : Yard Tree Private 2     9 Width 4ft   6001191.36102 2102681.58859 37.7536300665832 -122.438798157734 (37.7536300665832, -122.438798157734) 2 4 5 28862 22
115137 251332 DPW Maintained 1 Schinus molle :: California Pepper 91 920X Shotwell St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/08/2017 12:00:00 AM 3 3x3 Permit Number 779528 6007731 2102403 37.7532350085981 -122.416162845847 (37.7532350085981, -122.416162845847) 2 4 7 28859 19
115227 239665 DPW Maintained 1 Schinus molle :: California Pepper 91 3977 22nd St 7 : Tree Private 2     1     6001970.62949 2102924.44279 37.7543411893077 -122.436120656556 (37.7543411893077, -122.436120656556) 2 4 5 28862 22
117373 239600 DPW Maintained 1 Schinus molle :: California Pepper 91 4255 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 4ft   6000853.41096 2102858.4973 37.754096582697 -122.439979544931 (37.754096582697, -122.439979544931) 2 4 5 28862 22
119856 239663 DPW Maintained 1 Schinus molle :: California Pepper 91 1134 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     27 Width 5ft   6002486.58464 2102202.41494 37.7523879724368 -122.434284738254 (37.7523879724368, -122.434284738254) 2 4 5 28862 22
120428 239651 DPW Maintained 1 Schinus molle :: California Pepper 91 767 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6002456.2179 2103744.61211 37.7566207539655 -122.434500008976 (37.7566207539655, -122.434500008976) 2 4 5 28862 3
120800 239577 DPW Maintained 1 Schinus molle :: California Pepper 91 3961 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 5ft   6004128.58692 2100700.88045 37.7483581715004 -122.428499407621 (37.7483581715004, -122.428499407621) 2 4 5 63 22
121062 46566 Permitted Site 7 Schinus molle :: California Pepper 91 3900 22nd St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/02/2002 12:00:00 AM     Permit Number 44701 6002455.82917315 2102994.91492425 37.7545622428397 -122.434447752947 (37.7545622428397, -122.434447752947) 2 4 5 28862 22
122190 239601 DPW Maintained 1 Schinus molle :: California Pepper 91 4315 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6001018.49265 2103293.22516 37.7552996363918 -122.439439814104 (37.7552996363918, -122.439439814104) 2 4 5 28862 22
122621 33145 Permitted Site 7 Schinus molle :: California Pepper 91 4238 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/09/1996 12:00:00 AM     Permit Number 37370 6001375.34520428 2103384.04824408 37.7555693169237 -122.438212219782 (37.7555693169237, -122.438212219782) 2 4 5 28862 3
128342 239654 DPW Maintained 1 Schinus molle :: California Pepper 91 3512 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 3ft   6004884 2103735 37.7567318772846 -122.42610317358 (37.7567318772846, -122.42610317358) 2 4 5 28862 3
128408 239640 DPW Maintained 1 Schinus molle :: California Pepper 91 3627 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6004151.81834 2103627.38126 37.756394971966 -122.428627654542 (37.756394971966, -122.428627654542) 2 4 5 28862 22
131919 239655 DPW Maintained 1 Schinus molle :: California Pepper 91 315 Sanchez St 4 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6003584.30488 2106480.06785 37.7641956329586 -122.430793883956 (37.7641956329586, -122.430793883956) 8 4 5 28862 3
132442 239661 DPW Maintained 1 Schinus molle :: California Pepper 91 1128 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 6ft   6002484.84221 2102239.39907 37.7524894231662 -122.434293407712 (37.7524894231662, -122.434293407712) 2 4 5 28862 22
132503 239660 DPW Maintained 1 Schinus molle :: California Pepper 91 1116 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6002481.9632 2102282.2017 37.7526067855982 -122.434306423626 (37.7526067855982, -122.434306423626) 2 4 5 28862 22
134487 239620 DPW Maintained 1 Schinus molle :: California Pepper 91 455 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6001841.52504 2103217.25207 37.7551378375593 -122.436588089066 (37.7551378375593, -122.436588089066) 2 4 5 28862 22
135975 239619 DPW Maintained 1 Schinus molle :: California Pepper 91 4145 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 5ft   6001541.55358 2103483.24744 37.7558511456308 -122.437644524497 (37.7558511456308, -122.437644524497) 2 4 5 28862 22
136995 46069 Permitted Site 7 Schinus molle :: California Pepper 91 3746 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2001 12:00:00 AM     Permit Number 44454 6003440.19743527 2103634.04731282 37.7563729765603 -122.431089163341 (37.7563729765603, -122.431089163341) 2 4 5 28862 3
137040 104775 Undocumented 4 Schinus molle :: California Pepper 91 771 CASTRO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3   6002522.3 2103728.6 37.7565805395296 -122.434270328818 (37.7565805395296, -122.434270328818) 2 4 5 28862 3
137902 239618 DPW Maintained 1 Schinus molle :: California Pepper 91 703 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   6001824.43589 2102039.44346 37.751902886217 -122.436562889192 (37.751902886217, -122.436562889192) 2 4 5 28862 22
142827 239622 DPW Maintained 1 Schinus molle :: California Pepper 91 504 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6003013.03896 2103315.76974 37.7554748476953 -122.43254369215 (37.7554748476953, -122.43254369215) 2 4 5 28862 22
146475 239633 DPW Maintained 1 Schinus molle :: California Pepper 91 11 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6004102.43046 2102956.46643 37.7545500028912 -122.428750628764 (37.7545500028912, -122.428750628764) 2 4 5 28862 22
146750 239581 DPW Maintained 1 Schinus molle :: California Pepper 91 3537 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004768.88841 2103660.24792 37.756520118925 -122.426495949253 (37.756520118925, -122.426495949253) 2 4 5 28862 22
148538 66525 Permitted Site 7 Schinus molle :: California Pepper 91 4121 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1991 12:00:00 AM     Permit Number 29699 6002362.5628629 2102351.70560046 37.7527908488566 -122.434724299907 (37.7527908488566, -122.434724299907) 2 4 5 28862 22
149335 239579 DPW Maintained 1 Schinus molle :: California Pepper 91 4059 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 5ft   6003506.87632 2100667.44546 37.7482311647378 -122.430646881656 (37.7482311647378, -122.430646881656) 2 4 5 63 22
150336 239629 DPW Maintained 1 Schinus molle :: California Pepper 91 430 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6003569.47839 2102760.68831 37.753982264481 -122.430579748167 (37.753982264481, -122.430579748167) 2 4 5 28862 22
152333 239639 DPW Maintained 1 Schinus molle :: California Pepper 91 3615 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6004229.58112 2103632.14382 37.7564124493922 -122.428359063024 (37.7564124493922, -122.428359063024) 2 4 5 28862 22
155796 239653 DPW Maintained 1 Schinus molle :: California Pepper 91 3512 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   6004899.76423 2103707.095 37.7566561476773 -122.426046668635 (37.7566561476773, -122.426046668635) 2 4 5 28862 3
156673 63979 Permitted Site 7 Schinus molle :: California Pepper 91 801 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1987 12:00:00 AM     Permit Number 24719 6003748.05431866 2103616.18796413 37.7563413791419 -122.430023213091 (37.7563413791419, -122.430023213091) 2 4 5 28862 22
158555 104220 Permitted Site 7 Schinus molle :: California Pepper 91 642-652 Castro St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002365 2104465 37.7585935873912 -122.434866988999 (37.7585935873912, -122.434866988999) 2 4 5 28862 3
158691 112685 Undocumented 4 Schinus molle :: California Pepper 91 86 STANTON ST 2 Front Yard : Yard Tree Private 2       3x3   6000281 2103909 37.7569484049338 -122.442034474193 (37.7569484049338, -122.442034474193) 2 4 5 28862 38
159589 51810 Permitted Site 7 Schinus molle :: California Pepper 91 4432 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2005 12:00:00 AM     Permit Number 48056 6001326.40602228 2104686.21381833 37.7591419642331 -122.43847475852 (37.7591419642331, -122.43847475852) 2 4 5 28862 3
162055 99797 Undocumented 4 Schinus molle :: California Pepper 91 703-705 Elizabeth St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001860 2102041 37.7519091810186 -122.436440015083 (37.7519091810186, -122.436440015083) 2 4 5 28862 22
162473 239604 DPW Maintained 1 Schinus molle :: California Pepper 91 3980 22nd St 1 : Tree Private 2     1     6001965.58933 2102953.14284 37.7544197064144 -122.436140140357 (37.7544197064144, -122.436140140357) 2 4 5 28862 22
164036 46334 Permitted Site 7 Schinus molle :: California Pepper 91 3776 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2002 12:00:00 AM     Permit Number 44584 6005338.11992395 2101398.90311865 37.7503431540329 -122.424366507573 (37.7503431540329, -122.424366507573) 2 4 5 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)
);