trees
74 rows where Fire Prevention Districts = 9 and qSpecies_id = 133 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1063 | 32734 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 808 Capitol Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37117 | 5995081.95862964 | 2089664.82981262 | 37.7175397705127 | -122.458983271916 | (37.7175397705127, -122.458983271916) | 9 | 8 | 6 | 28861 | 24 | ||
8549 | 206676 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 240 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994971.50428 | 2095856.22795 | 37.7345335069973 | -122.459813287749 | (37.7345335069973, -122.459813287749) | 9 | 7 | 4 | 59 | 40 | |||
9795 | 94076 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53465 | 5996116 | 2095941 | 37.734832022473 | -122.455862534884 | (37.734832022473, -122.455862534884) | 9 | 7 | 4 | 59 | 40 | ||
13396 | 42456 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 570 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42599 | 5997659.71395367 | 2095289.95204904 | 37.7331328776169 | -122.450478486701 | (37.7331328776169, -122.450478486701) | 9 | 7 | 4 | 59 | 40 | ||
14716 | 39658 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 311 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41051 | 5995887.27205834 | 2090529.96858098 | 37.7199614976995 | -122.456262207219 | (37.7199614976995, -122.456262207219) | 9 | 8 | 6 | 28861 | 24 | ||
20331 | 95111 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 649 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54039 | 6001701.74477 | 2093288.67335 | 37.7278683408513 | -122.436360947301 | (37.7278683408513, -122.436360947301) | 9 | 7 | 6 | 28861 | 25 |
20681 | 206679 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 657 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995939.36036 | 2096013.8239 | 37.7350218397738 | -122.456478499997 | (37.7350218397738, -122.456478499997) | 9 | 7 | 4 | 59 | 40 | |||
21541 | 206683 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 647 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995995.17419 | 2096006.34018 | 37.7350044954584 | -122.456284991974 | (37.7350044954584, -122.456284991974) | 9 | 7 | 4 | 59 | 40 | |||
21549 | 94071 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 616 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53462 | 5996098 | 2095984 | 37.7349490569452 | -122.455927874303 | (37.7349490569452, -122.455927874303) | 9 | 7 | 4 | 59 | 40 | ||
28113 | 206685 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 641 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996053.59921 | 2095980.96691 | 37.734938180348 | -122.456081163331 | (37.734938180348, -122.456081163331) | 9 | 7 | 4 | 59 | 40 | |||
38958 | 40752 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 54 Cerritos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/13/1999 12:00:00 AM | Permit Number 41722 | 5992568.54395141 | 2093000.42735623 | 37.72655370366 | -122.46791340088 | (37.72655370366, -122.46791340088) | 9 | 8 | 4 | 59 | 40 | ||
45262 | 94075 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53465 | 5996116 | 2095941 | 37.734832022473 | -122.455862534884 | (37.734832022473, -122.455862534884) | 9 | 7 | 4 | 59 | 40 | ||
47735 | 206689 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 616 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996145.20311 | 2095954.15677 | 37.734869823774 | -122.455762520949 | (37.734869823774, -122.455762520949) | 9 | 7 | 4 | 59 | 40 | |||
47801 | 206671 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 370 Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995266.43425 | 2095204.88442 | 37.732762033223 | -122.458746484089 | (37.732762033223, -122.458746484089) | 9 | 7 | 4 | 59 | 40 | |||
49032 | 206680 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 657 Los Palmos Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995948.68471 | 2096013.62894 | 37.7350218397753 | -122.456446248507 | (37.7350218397753, -122.456446248507) | 9 | 7 | 4 | 59 | 40 | |||
52704 | 94078 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53465 | 5996116 | 2095941 | 37.734832022473 | -122.455862534884 | (37.734832022473, -122.455862534884) | 9 | 7 | 4 | 59 | 40 | ||
57524 | 47492 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 657 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 5 | Permit Number 45386 | 6001676.19021 | 2093232.03842 | 37.7277113821718 | -122.436445238065 | (37.7277113821718, -122.436445238065) | 9 | 7 | 6 | 28861 | 25 | |
58439 | 39660 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 316 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41052 | 5995871.10695115 | 2090582.25350935 | 37.7201041317861 | -122.456321862645 | (37.7201041317861, -122.456321862645) | 9 | 8 | 6 | 28861 | 24 | ||
64516 | 40751 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 54 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/13/1999 12:00:00 AM | Permit Number 41722 | 5992568.54395141 | 2093000.42735623 | 37.72655370366 | -122.46791340088 | (37.72655370366, -122.46791340088) | 9 | 8 | 4 | 59 | 40 | ||
68840 | 206686 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996075.55271 | 2095969.20127 | 37.7349071348466 | -122.456004412496 | (37.7349071348466, -122.456004412496) | 9 | 7 | 4 | 59 | 40 | |||
72421 | 206678 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 657 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995925.9256 | 2096013.73306 | 37.7350208190394 | -122.456524941888 | (37.7350208190394, -122.456524941888) | 9 | 7 | 4 | 59 | 40 | |||
79608 | 206693 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 609 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5997804.54909 | 2098010.1173 | 37.7406100866944 | -122.45017375512 | (37.7406100866944, -122.45017375512) | 9 | 7 | 4 | 59 | 40 | |||
80109 | 206672 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 370 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995263.98331 | 2095214.43939 | 37.732788127969 | -122.458755649049 | (37.732788127969, -122.458755649049) | 9 | 7 | 4 | 59 | 40 | |||
86717 | 206692 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 582 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996416.06092 | 2095880.87144 | 37.7346841407625 | -122.454820783252 | (37.7346841407625, -122.454820783252) | 9 | 7 | 4 | 59 | 40 | |||
87329 | 206675 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 300 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995199.65146 | 2095433.83543 | 37.733386838132 | -122.458993938825 | (37.733386838132, -122.458993938825) | 9 | 7 | 4 | 59 | 40 | |||
97367 | 206691 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 582 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5996439.41867 | 2095873.69496 | 37.7346657757093 | -122.454739509716 | (37.7346657757093, -122.454739509716) | 9 | 7 | 4 | 59 | 40 | |||
97453 | 206694 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 125 Chilton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001630.15209 | 2095380.35715 | 37.733607556928 | -122.43675811219 | (37.733607556928, -122.43675811219) | 9 | 7 | 5 | 63 | 40 | |||
99367 | 176074 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 786 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001892.13578 | 2089268.05693 | 37.7168394482606 | -122.435415271495 | (37.7168394482606, -122.435415271495) | 9 | 7 | 6 | 28861 | 5 | |||
100325 | 33392 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 161 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | Permit Number 37511 | 5993609.77804843 | 2093900.82209008 | 37.729086039701 | -122.464379267011 | (37.729086039701, -122.464379267011) | 9 | 8 | 4 | 59 | 40 | ||
101316 | 94077 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53465 | 5996116 | 2095941 | 37.734832022473 | -122.455862534884 | (37.734832022473, -122.455862534884) | 9 | 7 | 4 | 59 | 40 | ||
101641 | 35101 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 774 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38642 | 6001926.16682464 | 2089330.25640032 | 37.71701216685 | -122.435302089615 | (37.71701216685, -122.435302089615) | 9 | 7 | 6 | 28861 | 5 | ||
111864 | 206687 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996087.44674 | 2095957.96527 | 37.7348769661929 | -122.45596247889 | (37.7348769661929, -122.45596247889) | 9 | 7 | 4 | 59 | 40 | |||
117813 | 39659 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 311 Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41051 | 5995887.27205834 | 2090529.96858098 | 37.7199614976995 | -122.456262207219 | (37.7199614976995, -122.456262207219) | 9 | 8 | 6 | 28861 | 24 | ||
118553 | 206677 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 228 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994904.4684 | 2095946.32835 | 37.7347770452256 | -122.460051576629 | (37.7347770452256, -122.460051576629) | 9 | 7 | 4 | 59 | 40 | |||
122610 | 176075 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 100 Capistrano Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6001444.80034 | 2093622.381 | 37.7287700227166 | -122.4372730928 | (37.7287700227166, -122.4372730928) | 9 | 7 | 6 | 28861 | 25 | |||
124950 | 176073 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 774 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001923.16259 | 2089317.3719 | 37.7169766182659 | -122.43531155268 | (37.7169766182659, -122.43531155268) | 9 | 7 | 6 | 28861 | 5 | |||
126152 | 206533 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 665 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5995361.50595 | 2093791.16395 | 37.7288857636427 | -122.458315510062 | (37.7288857636427, -122.458315510062) | 9 | 7 | 4 | 28861 | 40 | |||
126227 | 206696 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 230 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6000774.6257 | 2094855.98841 | 37.7321191034008 | -122.439678327791 | (37.7321191034008, -122.439678327791) | 9 | 7 | 4 | 63 | 40 | |||
127288 | 206690 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 616 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996131.5818 | 2095962.98776 | 37.7348932897948 | -122.45581025245 | (37.7348932897948, -122.45581025245) | 9 | 7 | 4 | 59 | 40 | |||
128090 | 65685 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 265 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1990 12:00:00 AM | Permit Number 28609 | 5995018.52111157 | 2095862.640949 | 37.7345538192853 | -122.459651200361 | (37.7345538192853, -122.459651200361) | 9 | 7 | 4 | 59 | 40 | ||
128797 | 206534 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 665 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5995362.10243 | 2093779.40423 | 37.7288535085691 | -122.458312597175 | (37.7288535085691, -122.458312597175) | 9 | 7 | 4 | 28861 | 40 | |||
129524 | 117509 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 300x HANOVER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999715 | 2086521 | 37.7091727618039 | -122.442743399736 | (37.7091727618039, -122.442743399736) | 9 | 7 | 6 | 28861 | 5 | ||||
133547 | 206684 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 647 Los Palmos Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996011.49185 | 2096001.54035 | 37.7349922529962 | -122.456228229446 | (37.7349922529962, -122.456228229446) | 9 | 7 | 4 | 59 | 40 | |||
136667 | 206535 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 665 Miramar Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5995362.41808 | 2093767.65006 | 37.7288212525964 | -122.458310655534 | (37.7288212525964, -122.458310655534) | 9 | 7 | 4 | 28861 | 40 | |||
139505 | 206673 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 370 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995261.57654 | 2095226.10502 | 37.7328200206111 | -122.458764814062 | (37.7328200206111, -122.458764814062) | 9 | 7 | 4 | 59 | 40 | |||
154235 | 94070 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 616 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53462 | 5996098 | 2095984 | 37.7349490569452 | -122.455927874303 | (37.7349490569452, -122.455927874303) | 9 | 7 | 4 | 59 | 40 | ||
158105 | 206674 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 300 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995208.64941 | 2095407.77696 | 37.7333158051714 | -122.458960944512 | (37.7333158051714, -122.458960944512) | 9 | 7 | 4 | 59 | 40 | |||
164008 | 95110 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 649 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 54039 | 6001693.52474 | 2093271.82828 | 37.7278216210543 | -122.436388158988 | (37.7278216210543, -122.436388158988) | 9 | 7 | 6 | 28861 | 25 |
165991 | 206681 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 657 Los Palmos Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995960.60425 | 2096012.63655 | 37.735019799206 | -122.456404966934 | (37.735019799206, -122.456404966934) | 9 | 7 | 4 | 59 | 40 | |||
167854 | 206695 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 140 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001321.91458 | 2095363.51303 | 37.7335437842173 | -122.437822570471 | (37.7335437842173, -122.437822570471) | 9 | 7 | 5 | 63 | 40 | |||
172908 | 94074 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 628 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53464 | 5996021 | 2096021 | 37.7350462302618 | -122.456196763121 | (37.7350462302618, -122.456196763121) | 9 | 7 | 4 | 59 | 40 | ||
174811 | 161273 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 566 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 0 | Width 0ft | 6002889.18037 | 2090346.52899 | 37.7198572690851 | -122.432045948864 | (37.7198572690851, -122.432045948864) | 9 | 7 | 6 | 28861 | 5 | ||
175150 | 206682 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 647 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995986.28507 | 2096009.4987 | 37.7350126577011 | -122.456315952937 | (37.7350126577011, -122.456315952937) | 9 | 7 | 4 | 59 | 40 | |||
178877 | 72340 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 230 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51610 | 6000779.3756349 | 2094751.92568258 | 37.7318336416051 | -122.43965444862 | (37.7318336416051, -122.43965444862) | 9 | 7 | 4 | 63 | 40 | ||
180068 | 39661 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 316 Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41052 | 5995871.10695115 | 2090582.25350935 | 37.7201041317861 | -122.456321862645 | (37.7201041317861, -122.456321862645) | 9 | 8 | 6 | 28861 | 24 | ||
181962 | 206688 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 629 Los Palmos Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996101.05251 | 2095948.39142 | 37.7348514596286 | -122.455914747394 | (37.7348514596286, -122.455914747394) | 9 | 7 | 4 | 59 | 40 | |||
186101 | 206532 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 San Aleso Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993345.96317 | 2094536.94274 | 37.730817459756 | -122.46533747775 | (37.730817459756, -122.46533747775) | 9 | 8 | 4 | 59 | 40 | |||
187372 | 65683 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 234 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1990 12:00:00 AM | Permit Number 28607 | 5994926.44798675 | 2095898.35261594 | 37.7346465797712 | -122.459972111851 | (37.7346465797712, -122.459972111851) | 9 | 7 | 4 | 59 | 40 | ||
191070 | 40167 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 216 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1999 12:00:00 AM | Permit Number 41360 | 5994849.72626239 | 2095987.73496493 | 37.7348875889443 | -122.460243836722 | (37.7348875889443, -122.460243836722) | 9 | 7 | 4 | 59 | 40 | ||
194155 | 206531 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993348.57217 | 2094559.38972 | 37.7308792440863 | -122.465330088014 | (37.7308792440863, -122.465330088014) | 9 | 8 | 4 | 59 | 40 | |||
28142 | 121663 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998939 | 2095554 | 37.7339310276146 | -122.446074655004 | (37.7339310276146, -122.446074655004) | 9 | 7 | 4 | 59 | 40 | ||||
62246 | 121661 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998939 | 2095554 | 37.7339310276146 | -122.446074655004 | (37.7339310276146, -122.446074655004) | 9 | 7 | 4 | 59 | 40 | ||||
86826 | 121662 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998939 | 2095554 | 37.7339310276146 | -122.446074655004 | (37.7339310276146, -122.446074655004) | 9 | 7 | 4 | 59 | 40 | ||||
162377 | 121664 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998939 | 2095554 | 37.7339310276146 | -122.446074655004 | (37.7339310276146, -122.446074655004) | 9 | 7 | 4 | 59 | 40 | ||||
179732 | 121660 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998939 | 2095554 | 37.7339310276146 | -122.446074655004 | (37.7339310276146, -122.446074655004) | 9 | 7 | 4 | 59 | 40 | ||||
19680 | 206561 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 355 Yerba Buena Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5995302.34368 | 2095238.16689 | 37.732855482695 | -122.458624745542 | (37.732855482695, -122.458624745542) | 9 | 7 | 4 | 59 | 40 | |||
40567 | 206697 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998934.95382 | 2095541.69667 | 37.7338970145182 | -122.446087759167 | (37.7338970145182, -122.446087759167) | 9 | 7 | 4 | 59 | 40 | |||
66765 | 206560 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 355 Yerba Buena Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995304.48103 | 2095229.25095 | 37.7328311245367 | -122.458616711016 | (37.7328311245367, -122.458616711016) | 9 | 7 | 4 | 59 | 40 | |||
72896 | 206698 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998920.6207 | 2095542.64427 | 37.7338987978865 | -122.446137381059 | (37.7338987978865, -122.446137381059) | 9 | 7 | 4 | 59 | 40 | |||
96906 | 206702 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5998869.22619 | 2095565.73707 | 37.7339592701108 | -122.446316727449 | (37.7339592701108, -122.446316727449) | 9 | 7 | 4 | 59 | 40 | |||
108186 | 206701 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998876.80466 | 2095558.49789 | 37.7339398258586 | -122.446290005877 | (37.7339398258586, -122.446290005877) | 9 | 7 | 4 | 59 | 40 | |||
110640 | 206559 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 355 Yerba Buena Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5995306.63453 | 2095221.10602 | 37.7328088843117 | -122.458608676455 | (37.7328088843117, -122.458608676455) | 9 | 7 | 4 | 59 | 40 | |||
137361 | 206699 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998907.63682 | 2095545.72944 | 37.7339065275492 | -122.446182491946 | (37.7339065275492, -122.446182491946) | 9 | 7 | 4 | 59 | 40 | |||
180598 | 206700 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 860 Teresita Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998900.28229 | 2095547.61505 | 37.7339112849776 | -122.446208054284 | (37.7339112849776, -122.446208054284) | 9 | 7 | 4 | 59 | 40 |
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) );