trees
356 rows where qSpecies_id = 91 sorted by Supervisor Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
131779 | 4362 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 951 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001187.63557 | 2096055.63136 | 37.7354365441677 | -122.438336378342 | (37.7354365441677, -122.438336378342) | 2 | 7 | 5 | 63 | 7 | |||
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 | |||
135191 | 239568 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 547 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6003022.32339 | 2098879.77623 | 37.7432951790362 | -122.432194801972 | (37.7432951790362, -122.432194801972) | 2 | 7 | 5 | 63 | 22 | |||
135825 | 239592 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1643 Diamond St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6002072.60016 | 2099184.21674 | 37.7440772079026 | -122.435500467872 | (37.7440772079026, -122.435500467872) | 2 | 7 | 5 | 63 | 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 | |||
138709 | 52003 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 375 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/2005 12:00:00 AM | Permit Number 48220 | 6004122.23435698 | 2098354.44856915 | 37.7419150515767 | -122.428354161004 | (37.7419150515767, -122.428354161004) | 2 | 7 | 5 | 63 | 7 | ||
139465 | 247659 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 129 Divisadero St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6001899.88473 | 2108418.65056 | 37.7694229261437 | -122.436758580761 | (37.7694229261437, -122.436758580761) | 15 | 5 | 5 | 29492 | 9 | |||
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 | |||
160098 | 247665 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 126 Divisadero St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6001954.04638 | 2108418.01268 | 37.7694242526446 | -122.436571192619 | (37.7694242526446, -122.436571192619) | 15 | 5 | 5 | 29492 | 9 | |||
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 | ||
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 | |||
167969 | 41655 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 112 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2000 12:00:00 AM | Permit Number 42124 | 6001962.23129662 | 2108338.50531125 | 37.7692064101731 | -122.436537189813 | (37.7692064101731, -122.436537189813) | 15 | 5 | 5 | 29492 | 9 | |||
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 | ||
169066 | 239666 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 260 Beacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6002994.59568 | 2097812.95314 | 37.7403643577184 | -122.432214505197 | (37.7403643577184, -122.432214505197) | 2 | 7 | 5 | 63 | 7 | |||
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 | ||||
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 | |||
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 | |||
173467 | 35617 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 42 Walter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38971 | 6003128.23907612 | 2108063.84146095 | 37.7685184402848 | -122.432484413704 | (37.7685184402848, -122.432484413704) | 15 | 5 | 5 | 28862 | 3 | |||
175035 | 239590 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 732 Duncan St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 10ft | 6001765.51317 | 2099741.92053 | 37.745591085263 | -122.436602215635 | (37.745591085263, -122.436602215635) | 2 | 7 | 5 | 63 | 22 | |||
178192 | 64253 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 238 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | Permit Number 25052 | 6004384.37597616 | 2098713.60490953 | 37.7429160426191 | -122.427473340495 | (37.7429160426191, -122.427473340495) | 2 | 7 | 5 | 63 | 22 | ||
179689 | 239646 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 211 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004207.2629 | 2104504.88213 | 37.7588075193625 | -122.428498452559 | (37.7588075193625, -122.428498452559) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
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 | |||
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 | ||
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 | |||
186857 | 239569 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 541 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6003070.35446 | 2098885.05634 | 37.7433124001545 | -122.432029100079 | (37.7433124001545, -122.432029100079) | 2 | 7 | 5 | 63 | 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 | |||
189872 | 60508 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 282 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1987 12:00:00 AM | 3x3 | Permit Number 24310 | 6004065.51901322 | 2099574.2006491 | 37.7452610006153 | -122.428637192649 | (37.7452610006153, -122.428637192649) | 2 | 7 | 5 | 63 | 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 | ||||
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 | |||
193261 | 247657 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 165 Divisadero St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6001871.68544 | 2108600.41157 | 37.7699203942357 | -122.436869134409 | (37.7699203942357, -122.436869134409) | 15 | 5 | 5 | 29492 | 9 | |||
17752 | 70594 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 342 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 6004127.79616 | 2091299.57805 | 37.7225442769693 | -122.427832358882 | (37.7225442769693, -122.427832358882) | 9 | 7 | 6 | 28861 | 5 | |||
77871 | 214162 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 56 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995350.86908 | 2090273.63849 | 37.7192268694992 | -122.458097813856 | (37.7192268694992, -122.458097813856) | 9 | 8 | 6 | 28861 | 24 | |||
86523 | 179423 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 103 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6004767.82112 | 2092745.17359 | 37.7265497503523 | -122.425722776001 | (37.7265497503523, -122.425722776001) | 9 | 7 | 6 | 28861 | 5 | ||||
115611 | 214163 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 274 Tara St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5997748.47431 | 2090294.62139 | 37.7194219549502 | -122.449811751014 | (37.7194219549502, -122.449811751014) | 9 | 8 | 6 | 28861 | 24 | |||
185878 | 32430 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 36 Tingley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/1996 12:00:00 AM | 16 | Permit Number 36957 | 6002798.58811 | 2093563.75666 | 37.7286859198974 | -122.432588778773 | (37.7286859198974, -122.432588778773) | 9 | 7 | 6 | 28861 | 25 | ||
8068 | 32395 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 222 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1996 12:00:00 AM | 6 | 8x6 | Permit Number 36936 | 6005810.68419 | 2096104.55108 | 37.735832735077 | -122.42235621788 | (37.735832735077, -122.42235621788) | 2 | 7 | 7 | 28859 | 2 |
11161 | 247593 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 800 Tompkins Ave | 14 | Front Yard : Yard | Tree | Private 2 | 11 | 6009015.3685 | 2096434.58029 | 37.736919178173 | -122.411299627995 | (37.736919178173, -122.411299627995) | 10 | 7 | 7 | 28859 | 2 | ||||
23648 | 239611 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 230 Esmeralda Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6007188.60592 | 2098802.03139 | 37.7433170496408 | -122.417783333431 | (37.7433170496408, -122.417783333431) | 2 | 7 | 7 | 28859 | 2 | |||
27405 | 33584 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 149 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37692 | 6007187.40748461 | 2098136.50319387 | 37.7414895902405 | -122.417740314034 | (37.7414895902405, -122.417740314034) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |
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 | |
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 | |||
59175 | 46762 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 220 Esmeralda Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | 14 | 6x5 | Permit Number 44860 | 6007156.68652731 | 2098808.76351871 | 37.7433337382313 | -122.417894179823 | (37.7433337382313, -122.417894179823) | 2 | 7 | 7 | 28859 | 2 |
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 | |||
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 | |
63489 | 113030 | Undocumented 4 | Schinus molle :: California Pepper 91 | 200x ESMERALDA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 9x9 | 6007093 | 2098828 | 37.7433829729046 | -122.41811575542 | (37.7433829729046, -122.41811575542) | 2 | 7 | 7 | 28859 | 2 | |||
81834 | 239609 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 98 Winfield St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 25 | Width 3ft | 6007121.02113 | 2098861.91271 | 37.7434776667546 | -122.41802126889 | (37.7434776667546, -122.41802126889) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | ||
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 | |
98484 | 239610 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 342 Prospect Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 3ft | 6006341.94877 | 2097874.88988 | 37.7407236449682 | -122.420645058033 | (37.7407236449682, -122.420645058033) | 2 | 7 | 7 | 28859 | 2 | |||
98903 | 239612 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 220 Esmeralda Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6007237.85888 | 2098768.99356 | 37.7432291067493 | -122.417610687906 | (37.7432291067493, -122.417610687906) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
112033 | 239613 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 200 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007098.78535 | 2096984.45251 | 37.7383213273752 | -122.417965090943 | (37.7383213273752, -122.417965090943) | 2 | 7 | 7 | 28859 | 2 | |||
112273 | 179424 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 367 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6005868 | 2092014 | 37.7246042151677 | -122.421867578972 | (37.7246042151677, -122.421867578972) | 9 | 7 | 7 | 309 | 5 | |||
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 | |
124417 | 239608 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 149 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007254.62958 | 2098290.95874 | 37.7419174734269 | -122.417518826646 | (37.7419174734269, -122.417518826646) | 2 | 7 | 7 | 28859 | 2 | |||
129788 | 239614 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 249 Precita Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007957.74109 | 2100292.59771 | 37.7474530659031 | -122.41522934697 | (37.7474530659031, -122.41522934697) | 2 | 7 | 7 | 28859 | 2 | |||
134061 | 239607 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 189 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6007238.5342 | 2097885.55109 | 37.7408034085529 | -122.417545753258 | (37.7408034085529, -122.417545753258) | 2 | 7 | 7 | 28859 | 2 | |||
137756 | 239587 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 105 Elsie St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 5ft | 6007266.87289 | 2098693.35025 | 37.7430230396951 | -122.417505004957 | (37.7430230396951, -122.417505004957) | 2 | 7 | 7 | 28859 | 2 | |||
146935 | 239586 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 103 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007116.95324 | 2098786.33455 | 37.743269917082 | -122.418029977927 | (37.743269917082, -122.418029977927) | 2 | 7 | 7 | 28859 | 2 | |||
151790 | 63720 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 249 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1987 12:00:00 AM | 12 | 3x3 | Permit Number 24385 | 6008064.48787212 | 2100278.68429699 | 37.7474208614245 | -122.41485923795 | (37.7474208614245, -122.41485923795) | 2 | 7 | 7 | 28859 | 2 |
156347 | 63010 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 9 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1986 12:00:00 AM | Permit Number 23424 | 6007395.1381387 | 2098224.27155142 | 37.7417422703287 | -122.417028268249 | (37.7417422703287, -122.417028268249) | 2 | 7 | 7 | 28859 | 2 | ||
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 | |
167131 | 247586 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 800 Tompkins Ave | 7 | Front Yard : Yard | Tree | Private 2 | 21 | 6008976.64658 | 2096466.10816 | 37.7370035750634 | -122.411435734088 | (37.7370035750634, -122.411435734088) | 10 | 7 | 7 | 28859 | 2 | ||||
172414 | 256223 | Property Tree 8 | Schinus molle :: California Pepper 91 | 116X Brewster St | 1 | Sidewalk: Property side : Yard | Tree | Rec/Park 5 | 6x6 | 6010334 | 2099321 | 37.7449185312124 | -122.406943891675 | (37.7449185312124, -122.406943891675) | 2 | 7 | 7 | 28859 | 2 | ||||
175778 | 33535 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 189 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | 14 | 4x4 | Permit Number 37645 | 6007254.14606577 | 2097898.03626592 | 37.7408385685157 | -122.417492657782 | (37.7408385685157, -122.417492657782) | 2 | 7 | 7 | 28859 | 2 | |
188533 | 239615 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 249 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007977.56297 | 2100289.57669 | 37.7474458848375 | -122.4151605902 | (37.7474458848375, -122.4151605902) | 2 | 7 | 7 | 28859 | 2 | |||
3344 | 197494 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 401 Texas St | 3 | : | Tree | Private 2 | 23 | Width 7ft | 6013811.84722 | 2105166.53521 | 37.7611631145139 | -122.395327465206 | (37.7611631145139, -122.395327465206) | 10 | 3 | 8 | 28856 | 29 | |||
3568 | 197493 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 950x Kansas St | 7 | Median : Yard | Tree | DPW 1 | 25 | 6011595.70122 | 2103803.27065 | 37.7572963894245 | -122.402896325021 | (37.7572963894245, -122.402896325021) | 10 | 3 | 8 | 28856 | 29 | ||||
6035 | 264650 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2400 Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014365 | 2092317 | 37.7259117231873 | -122.392515496721 | (37.7259117231873, -122.392515496721) | 10 | 3 | 8 | 58 | 1 | ||||
6293 | 97158 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012744.23117 | 2089823.98249 | 37.7189762599209 | -122.397943616401 | (37.7189762599209, -122.397943616401) | 10 | 3 | 8 | 58 | 1 | ||
6990 | 97154 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 4 | Permit Number 768080 | 6012676.26956 | 2089874.1029 | 37.7191100952408 | -122.398182049174 | (37.7191100952408, -122.398182049174) | 10 | 3 | 8 | 58 | 1 | ||
7042 | 264648 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2400 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014365 | 2092317 | 37.7259117231873 | -122.392515496721 | (37.7259117231873, -122.392515496721) | 10 | 3 | 8 | 58 | 1 | ||||
7939 | 264649 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2400 Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014365 | 2092317 | 37.7259117231873 | -122.392515496721 | (37.7259117231873, -122.392515496721) | 10 | 3 | 8 | 58 | 1 | ||||
9816 | 32952 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 673X Missouri St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1996 12:00:00 AM | Permit Number 37269 | 6013554 | 2103938 | 37.7577754809094 | -122.396133153567 | (37.7577754809094, -122.396133153567) | 10 | 3 | 8 | 28856 | 29 | |||
12625 | 97159 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012757.60574 | 2089814.3813 | 37.7189506418481 | -122.397896712286 | (37.7189506418481, -122.397896712286) | 10 | 3 | 8 | 58 | 1 | ||
12626 | 97156 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012721.62132 | 2089840.20593 | 37.7190195469812 | -122.398022907844 | (37.7190195469812, -122.398022907844) | 10 | 3 | 8 | 58 | 1 | ||
16110 | 173720 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1799x 25th St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6013424 | 2101939 | 37.7522794251173 | -122.396442635345 | (37.7522794251173, -122.396442635345) | 10 | 3 | 8 | 28856 | 1 |
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) );