trees

114 rows where Police Districts = 4 and qSpecies_id = 91 sorted by Location

✎ 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)
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
181859 239580 DPW Maintained 1 Schinus molle :: California Pepper 91 4019 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 5ft   6003715.87137 2100677.69284 37.748271139596 -122.429924914027 (37.748271139596, -122.429924914027) 2 4 5 63 22
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
193003 239631 DPW Maintained 1 Schinus molle :: California Pepper 91 3946 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6003468.88792 2102461.3534 37.7531546624799 -122.430906252449 (37.7531546624799, -122.430906252449) 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
166862 166073 DPW Maintained 1 Schinus molle :: California Pepper 91 920X Shotwell St 1 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
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
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
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
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
185270 239632 DPW Maintained 1 Schinus molle :: California Pepper 91 87 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6004121.65636 2102563.78903 37.7534728911634 -122.428656150459 (37.7534728911634, -122.428656150459) 2 4 5 28862 22
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
191230 88822 Permitted Site 7 Schinus molle :: California Pepper 91 1011 Castro St   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 51709 6002511 2102645 37.7536045914774 -122.434231943794 (37.7536045914774, -122.434231943794) 2 4 5 28862 22
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
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
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
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
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
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
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
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
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
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
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
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
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
186484 109125 Private 9 Schinus molle :: California Pepper 91 890x CASTRO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002411 2103002 37.7545791519678 -122.434603290485 (37.7545791519678, -122.434603290485) 2 4 5 28862 22
166727 239603 DPW Maintained 1 Schinus molle :: California Pepper 91 890 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6002439.95737 2103017.51215 37.7546233884599 -122.434504257392 (37.7546233884599, -122.434504257392) 2 4 5 28862 22
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
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
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
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
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
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
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
168602 62517 Permitted Site 7 Schinus molle :: California Pepper 91 4315 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/15/1986 12:00:00 AM     Permit Number 22698 6001100.3292402 2103290.9987582 37.7552981802714 -122.439156639775 (37.7552981802714, -122.439156639775) 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
185477 52692 Permitted Site 7 Schinus molle :: California Pepper 91 4362ON CASTRO 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/30/2006 12:00:00 AM     Permit Number 48760 6000868.9362336 2103304.07672076 37.755320919647 -122.439957801702 (37.755320919647, -122.439957801702) 2 4 5 28862 38
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
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
169418 239623 DPW Maintained 1 Schinus molle :: California Pepper 91 514 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6002886.08981 2103305.68045 37.7554399450095 -122.432982000136 (37.7554399450095, -122.432982000136) 2 4 5 28862 22
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
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
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
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
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
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
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
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
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
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
189202 239636 DPW Maintained 1 Schinus molle :: California Pepper 91 3691 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003794.28038 2103601.33494 37.7563032141343 -122.429862287926 (37.7563032141343, -122.429862287926) 2 4 5 28862 22
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
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
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
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
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
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
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
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
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
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
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
169330 239650 DPW Maintained 1 Schinus molle :: California Pepper 91 771 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6002455.69585 2103719.36042 37.7565513892455 -122.434500008966 (37.7565513892455, -122.434500008966) 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
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
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
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
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
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
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
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
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
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
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
169069 112686 Undocumented 4 Schinus molle :: California Pepper 91 86 STANTON ST 3 Front Yard : Yard Tree Private 2       3x3   6000281 2103909 37.7569484049338 -122.442034474193 (37.7569484049338, -122.442034474193) 2 4 5 28862 38
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

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