trees
858 rows where qSpecies_id = 85 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
61511 | 28704 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3004 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2008 12:00:00 AM | 16 | 3x3 | 6011587.3423 | 2091581.4466 | 37.7237373984555 | -122.402066038858 | (37.7237373984555, -122.402066038858) | 10 | 3 | 7 | 309 | 28 | ||
52207 | 197781 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1950 18th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6011867.97077 | 2105631.0205 | 37.7623301845026 | -122.402083196704 | (37.7623301845026, -122.402083196704) | 8 | 3 | 8 | 28856 | 29 | |||
187306 | 187410 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3004 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6011579.9826 | 2091598.2688 | 37.723783177983 | -122.402092662329 | (37.723783177983, -122.402092662329) | 10 | 3 | 7 | 309 | 28 | |||
57224 | 197782 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1950 18th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6011843.38352 | 2105630.34808 | 37.7623269658286 | -122.402168188035 | (37.7623269658286, -122.402168188035) | 8 | 3 | 8 | 28856 | 29 | |||
171464 | 197754 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 477 Morris St | 4 | : | Tree | Private 2 | 15 | Width 3ft | 6011947.90885 | 2110817.9298 | 37.7765767245667 | -122.402171403986 | (37.7765767245667, -122.402171403986) | 14 | 2 | 9 | 28856 | 34 | |||
64630 | 197753 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 477 Morris St | 3 | : | Tree | Private 2 | 14 | Width 3ft | 6011938.94359 | 2110826.29932 | 37.7765992049252 | -122.402203006171 | (37.7765992049252, -122.402203006171) | 14 | 2 | 9 | 28856 | 34 | |||
153088 | 197752 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 477 Morris St | 2 | : | Tree | Private 2 | 14 | Width 3ft | 6011931.78644 | 2110833.72253 | 37.7766191878522 | -122.402228287011 | (37.7766191878522, -122.402228287011) | 14 | 2 | 9 | 28856 | 34 | |||
94951 | 40575 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 16 | Permit Number 42197 | 6011865.56753 | 2107924.68372 | 37.7686279344547 | -122.402252780039 | (37.7686279344547, -122.402252780039) | 8 | 2 | 8 | 28853 | 20 | |
109641 | 197751 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 477 Morris St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6011923.70688 | 2110840.70923 | 37.7766379207291 | -122.402256728071 | (37.7766379207291, -122.402256728071) | 14 | 2 | 9 | 28856 | 34 | |||
129206 | 40576 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 16 | Permit Number 42197 | 6011845.30553 | 2107921.74272 | 37.7686187280976 | -122.402322658262 | (37.7686187280976, -122.402322658262) | 8 | 2 | 8 | 28853 | 20 | |
74181 | 40602 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 15 | Permit Number 47084 | 6011826.18199 | 2107919.61674 | 37.7686118231125 | -122.40238865592 | (37.7686118231125, -122.40238865592) | 8 | 2 | 8 | 28853 | 20 | |
139752 | 40581 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 18 | Permit Number 47084 | 6011805.12388 | 2107918.92734 | 37.7686087546157 | -122.402461446151 | (37.7686087546157, -122.402461446151) | 8 | 2 | 8 | 28853 | 20 | |
131971 | 40579 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 14 | Permit Number 47084 | 6011781.78779 | 2107916.60765 | 37.7686010824916 | -122.402542001114 | (37.7686010824916, -122.402542001114) | 8 | 2 | 8 | 28853 | 20 | |
154583 | 187424 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2895 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6011445.1418 | 2092205.1836 | 37.725442113939 | -122.402601446022 | (37.725442113939, -122.402601446022) | 10 | 3 | 7 | 309 | 28 | |||
153181 | 40599 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 15 | Permit Number 47084 | 6011762.41247 | 2107915.88375 | 37.7685980131212 | -122.402608968236 | (37.7685980131212, -122.402608968236) | 8 | 2 | 8 | 28853 | 20 | |
150039 | 24901 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2895 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2015 12:00:00 AM | 16 | 3X9 | 6011438.8335 | 2092223.5829 | 37.7254922824246 | -122.40262454667 | (37.7254922824246, -122.40262454667) | 10 | 3 | 7 | 309 | 28 | ||
138467 | 40600 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 16 | Permit Number 47084 | 6011742.75079 | 2107914.88662 | 37.768594177497 | -122.402676906637 | (37.768594177497, -122.402676906637) | 8 | 2 | 8 | 28853 | 20 | |
19679 | 40601 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 13 | Permit Number 47084 | 6011717.76597 | 2107914.27714 | 37.7685911090192 | -122.402763284706 | (37.7685911090192, -122.402763284706) | 8 | 2 | 8 | 28853 | 20 | |
181892 | 24892 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2780 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 6011265.8799 | 2092627.3166 | 37.7265911939411 | -122.403250823482 | (37.7265911939411, -122.403250823482) | 10 | 3 | 7 | 309 | 28 | |||
177251 | 24891 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2780 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 2X2 | 6011255.8917 | 2092657.807 | 37.7266743564217 | -122.403287496484 | (37.7266743564217, -122.403287496484) | 10 | 3 | 7 | 309 | 28 | |||
48698 | 108284 | Undocumented 4 | Syagrus romanzoffianum :: Queen Palm 85 | 1 HENRY ADAMS ST | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 16 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | |||
34629 | 197801 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 816 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6011521.16357 | 2109490.57736 | 37.7729082910133 | -122.403554237551 | (37.7729082910133, -122.403554237551) | 14 | 2 | 9 | 28853 | 34 | |||
126409 | 179617 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 105 Burrows St | 3 | Side Yard : Yard | Tree | Private 2 | 4 | 6011176.00009 | 2093481.48046 | 37.7289315301509 | -122.403621608451 | (37.7289315301509, -122.403621608451) | 10 | 3 | 7 | 309 | 28 | ||||
33656 | 179619 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 104 Burrows St | 2 | Side Yard : Yard | Tree | Private 2 | 4 | 6011168.71552 | 2093496.29206 | 37.7289717927968 | -122.4036478336 | (37.7289717927968, -122.4036478336) | 10 | 3 | 7 | 309 | 28 | ||||
154017 | 179618 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 104 Burrows St | 1 | Side Yard : Yard | Tree | Private 2 | 6 | 6011168.50385 | 2093508.14959 | 37.7290043392774 | -122.403649399324 | (37.7290043392774, -122.403649399324) | 10 | 3 | 7 | 309 | 28 | ||||
124586 | 197802 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 816 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011487.83724 | 2109458.15845 | 37.7728174145236 | -122.403667236476 | (37.7728174145236, -122.403667236476) | 14 | 2 | 9 | 28853 | 34 | |||
108001 | 35885 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 65 Elmira St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | 3 | Permit Number 39085 | 6011186.47786 | 2096510.21791 | 37.7372483911964 | -122.403798418789 | (37.7372483911964, -122.403798418789) | 10 | 3 | 8 | 58 | 1 | |
139655 | 87541 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2603 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6011083.9894 | 2093392.2028 | 37.7286812521687 | -122.403933417809 | (37.7286812521687, -122.403933417809) | 10 | 3 | 7 | 309 | 28 | ||||
97531 | 28700 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2593 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2008 12:00:00 AM | 16 | 3x3 | 6011048.2422 | 2093513.6383 | 37.7290126914729 | -122.404065541323 | (37.7290126914729, -122.404065541323) | 10 | 3 | 7 | 309 | 28 | ||
86288 | 24937 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2591 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2001 12:00:00 AM | 16 | 3X3 | 6011042.03793 | 2093526.3228 | 37.7290471738075 | -122.404087882402 | (37.7290471738075, -122.404087882402) | 10 | 3 | 7 | 309 | 28 | ||
95311 | 187423 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2591 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6011041.4081 | 2093531.5119 | 37.7290613868014 | -122.404090424829 | (37.7290613868014, -122.404090424829) | 10 | 3 | 7 | 309 | 28 | |||
80860 | 33863 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 281 Clara St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/1997 12:00:00 AM | 9 | Permit Number 37859 | 6011402.4962 | 2111360.89694 | 37.7780371282385 | -122.404096375858 | (37.7780371282385, -122.404096375858) | 14 | 2 | 9 | 28856 | 34 | ||
25868 | 87525 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2600 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x8 | 6011029.3764 | 2093400.1095 | 37.7286999109797 | -122.404122775515 | (37.7286999109797, -122.404122775515) | 10 | 3 | 7 | 309 | 28 | |||
109417 | 87526 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2602 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x8 | 6011024.729699 | 2093421.52877 | 37.7287584641902 | -122.40414034637 | (37.7287584641902, -122.40414034637) | 10 | 3 | 7 | 309 | 28 | |||
53573 | 93802 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 21 Bishop St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 6010948.90983 | 2089721.21702 | 37.7185939356312 | -122.404142145962 | (37.7185939356312, -122.404142145962) | 10 | 7 | 8 | 309 | 39 | ||||
109214 | 240881 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2318 22nd St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6011232.67405 | 2103729.80119 | 37.7570743809943 | -122.404146651544 | (37.7570743809943, -122.404146651544) | 10 | 4 | 8 | 28859 | 19 | |||
94598 | 240880 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2318 22nd St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6011232.06922 | 2103723.4899 | 37.7570570177965 | -122.40414829912 | (37.7570570177965, -122.40414829912) | 10 | 4 | 8 | 28859 | 19 | ||||
105569 | 49744 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 27 Bishop St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 12 | Permit Number 46543 | 6010938.20638 | 2089696.59945 | 37.7185257427455 | -122.404177411982 | (37.7185257427455, -122.404177411982) | 10 | 7 | 8 | 309 | 39 | |
112406 | 197749 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 285 Clara St | 1 | : | Tree | Private 2 | 11 | Width 2ft | 6011375.02403 | 2111337.26592 | 37.7779707079309 | -122.404189748854 | (37.7779707079309, -122.404189748854) | 14 | 2 | 9 | 28856 | 34 | |||
84176 | 179592 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 33 Bishop St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010924.14414 | 2089655.49375 | 37.7184120891289 | -122.404223128119 | (37.7184120891289, -122.404223128119) | 10 | 7 | 8 | 309 | 39 | |||
104996 | 179589 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 40 Bishop St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6010901.30709 | 2089684.55651 | 37.718490613421 | -122.404304111153 | (37.718490613421, -122.404304111153) | 10 | 7 | 8 | 309 | 39 | |||
16960 | 179590 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 40 Bishop St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010898.94901 | 2089680.08922 | 37.7184782153849 | -122.404311947847 | (37.7184782153849, -122.404311947847) | 10 | 7 | 8 | 309 | 39 | |||
623 | 179591 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 46 Bishop St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010887.64563 | 2089644.57166 | 37.7183800597759 | -122.404348520588 | (37.7183800597759, -122.404348520588) | 10 | 7 | 8 | 309 | 39 | |||
156412 | 197803 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 850 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011246.96295 | 2109228.4267 | 37.7721731654036 | -122.404484278649 | (37.7721731654036, -122.404484278649) | 14 | 2 | 9 | 28853 | 34 | |||
57294 | 87534 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2515 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 6010931.8007 | 2093898.1841 | 37.7300620671282 | -122.404495148402 | (37.7300620671282, -122.404495148402) | 10 | 3 | 7 | 309 | 28 | ||||
41360 | 197804 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 850 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6011235.3992 | 2109217.88632 | 37.7721435776893 | -122.404523536758 | (37.7721435776893, -122.404523536758) | 14 | 2 | 9 | 28853 | 34 | |||
163930 | 197805 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 850 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011223.85709 | 2109208.39656 | 37.772116875933 | -122.40456279395 | (37.772116875933, -122.40456279395) | 14 | 2 | 9 | 28853 | 34 | |||
187422 | 24858 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2500 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/16/2001 12:00:00 AM | 20 | 3X4 | 6010904.8349 | 2093807.9386 | 37.7298127648541 | -122.404582022711 | (37.7298127648541, -122.404582022711) | 10 | 3 | 7 | 309 | 28 | ||
110157 | 197806 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 850 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011212.56245 | 2109198.11372 | 37.7720880103782 | -122.404601139252 | (37.7720880103782, -122.404601139252) | 14 | 2 | 9 | 28853 | 34 | |||
83846 | 24857 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2500 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/1996 12:00:00 AM | 20 | 3X3 | 6010898.5282 | 2093826.1579 | 37.7298624387628 | -122.404605107856 | (37.7298624387628, -122.404605107856) | 10 | 3 | 7 | 309 | 28 | ||
142958 | 179584 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 320 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 1ft | 6010797.22777 | 2090997.12631 | 37.7220888441036 | -122.40475622822 | (37.7220888441036, -122.40475622822) | 10 | 3 | 7 | 309 | 28 | |||
172903 | 87419 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2488 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 4x8 | 6010849.4762 | 2093988.7302 | 37.7303060866215 | -122.404786128142 | (37.7303060866215, -122.404786128142) | 10 | 3 | 7 | 309 | 28 | |||
50843 | 179585 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 320 Olmstead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 1ft | 6010784.99943 | 2090994.75272 | 37.7220816432233 | -122.404798331783 | (37.7220816432233, -122.404798331783) | 10 | 3 | 7 | 309 | 28 | |||
187000 | 87418 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2488 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 4x8 | 6010844.0455 | 2094008.351 | 37.730359657675 | -122.404806283739 | (37.730359657675, -122.404806283739) | 10 | 3 | 7 | 309 | 28 | |||
109461 | 179586 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 320 Olmstead St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 1ft | 6010772.40184 | 2090990.42019 | 37.7220690428431 | -122.404841573902 | (37.7220690428431, -122.404841573902) | 10 | 3 | 7 | 309 | 28 | |||
52724 | 250213 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 300 Filbert St | 2 | Front Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011356.8747 | 2120078.79875 | 37.8019718623651 | -122.404868140773 | (37.8019718623651, -122.404868140773) | 3 | 1 | 10 | 308 | 23 | |||
133656 | 179587 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 320 Olmstead St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 1ft | 6010760.46271 | 2090986.07392 | 37.7220564415258 | -122.404882538894 | (37.7220564415258, -122.404882538894) | 10 | 3 | 7 | 309 | 28 | |||
172749 | 24855 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2450 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/1996 12:00:00 AM | 15 | 3x3 | 6010769.7667 | 2094249.4065 | 37.731017393341 | -122.405080044104 | (37.731017393341, -122.405080044104) | 10 | 3 | 7 | 309 | 28 | ||
35836 | 179593 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 78 Tucker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010613.233 | 2088708.1848 | 37.7157935942767 | -122.40523115211 | (37.7157935942767, -122.40523115211) | 9 | 7 | 8 | 309 | 39 | |||
79080 | 64359 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 369 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | 11 | Permit Number 25197 | 6011195.22959 | 2119324.38957 | 37.7998914022152 | -122.405374352958 | (37.7998914022152, -122.405374352958) | 3 | 1 | 10 | 308 | 23 | |
19243 | 197785 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2347 19th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6010748.45807 | 2105046.89477 | 37.7606637578537 | -122.405914042413 | (37.7606637578537, -122.405914042413) | 10 | 3 | 8 | 28856 | 29 | ||||
5526 | 71641 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1327 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6011027.0266 | 2119468.0848 | 37.800276548465 | -122.405966529737 | (37.800276548465, -122.405966529737) | 3 | 1 | 10 | 308 | 23 | |||
36408 | 83343 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1327 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50763 | 6011023.37395305 | 2119422.18641329 | 37.8001503184077 | -122.405975934235 | (37.8001503184077, -122.405975934235) | 3 | 1 | 10 | 308 | 23 | ||
174649 | 24882 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2350 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2X2 | 6010484.31378 | 2095044.62979 | 37.733184946628 | -122.406122911744 | (37.733184946628, -122.406122911744) | 10 | 3 | 7 | 309 | 28 | |||
562 | 18470 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2003 12:00:00 AM | 12 | 3X3 | 6010619.64201 | 2102143.08548 | 37.7526833394657 | -122.406154975289 | (37.7526833394657, -122.406154975289) | 10 | 4 | 8 | 28859 | 19 | ||
180228 | 104631 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 2350 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2013 12:00:00 AM | 3x3 | Permit Number 770599 | 6010469.4 | 2095032.4 | 37.7331505320264 | -122.406173611635 | (37.7331505320264, -122.406173611635) | 10 | 3 | 7 | 309 | 28 | ||
24505 | 179621 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 599 Somerset St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6010365.10231 | 2091621.97451 | 37.7237803852281 | -122.406293990689 | (37.7237803852281, -122.406293990689) | 10 | 3 | 7 | 309 | 28 | |||
146785 | 179622 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 599 Somerset St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6010361.21232 | 2091638.86279 | 37.7238265393343 | -122.406308627159 | (37.7238265393343, -122.406308627159) | 10 | 3 | 7 | 309 | 28 | |||
140047 | 179623 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 599 Somerset St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6010356.36169 | 2091656.05003 | 37.7238734605828 | -122.406326605493 | (37.7238734605828, -122.406326605493) | 10 | 3 | 7 | 309 | 28 | |||
8388 | 179624 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 599 Somerset St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6010352.88812 | 2091667.17419 | 37.7239038109035 | -122.406339396551 | (37.7239038109035, -122.406339396551) | 10 | 3 | 7 | 309 | 28 | |||
133663 | 179625 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 599 Somerset St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6010348.90515 | 2091680.51921 | 37.7239402307466 | -122.406354104951 | (37.7239402307466, -122.406354104951) | 10 | 3 | 7 | 309 | 28 | |||
170775 | 179626 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 599 Somerset St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 6010345.77162 | 2091690.1629 | 37.7239665350232 | -122.406365616296 | (37.7239665350232, -122.406365616296) | 10 | 3 | 7 | 309 | 28 | |||
103161 | 179627 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 599 Somerset St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6010336.72583 | 2091718.34914 | 37.7240434225456 | -122.406398871428 | (37.7240434225456, -122.406398871428) | 10 | 3 | 7 | 309 | 28 | |||
26992 | 179620 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 602 Somerset St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6010330.79398 | 2091554.32638 | 37.7235927183043 | -122.40640782506 | (37.7235927183043, -122.40640782506) | 10 | 3 | 7 | 309 | 28 | |||
174603 | 179628 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 599 Somerset St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 6010332.78013 | 2091733.53575 | 37.7240849010885 | -122.406413580748 | (37.7240849010885, -122.406413580748) | 10 | 3 | 7 | 309 | 28 | |||
119337 | 240854 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1072 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010485.0248 | 2102978.73078 | 37.7549703055524 | -122.40667939245 | (37.7549703055524, -122.40667939245) | 10 | 4 | 7 | 28859 | 19 | |||
126882 | 117576 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 100 Waverly Pl | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | 3x3 | 6010746.80079 | 2117296.55701 | 37.7942983844173 | -122.406783100465 | (37.7942983844173, -122.406783100465) | 3 | 1 | 10 | 28857 | 4 | |||
94918 | 61868 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1352 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/2005 12:00:00 AM | Permit Number 21908 | 6010316.20997421 | 2101337.00017342 | 37.7504530304494 | -122.407147486405 | (37.7504530304494, -122.407147486405) | 2 | 4 | 7 | 28859 | 19 | ||
8080 | 75081 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 172 Russ St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 8x9 | 6010488.28034 | 2111342.37314 | 37.7779351433246 | -122.407257684389 | (37.7779351433246, -122.407257684389) | 14 | 2 | 9 | 28853 | 34 | |||
158392 | 245252 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1090 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010233.59348 | 2102899.19356 | 37.7547378433872 | -122.407543309979 | (37.7547378433872, -122.407543309979) | 2 | 4 | 7 | 28859 | 19 | |||
37580 | 245253 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1090 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010233.17575 | 2102878.70236 | 37.7546815557325 | -122.40754330998 | (37.7546815557325, -122.40754330998) | 2 | 4 | 7 | 28859 | 19 | |||
158777 | 245243 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2750 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6010216.08393 | 2102832.4172 | 37.7545535102617 | -122.407599155192 | (37.7545535102617, -122.407599155192) | 2 | 4 | 7 | 28859 | 19 | |||
137214 | 248022 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 501 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6009976.68855 | 2098377.46045 | 37.7423077764783 | -122.408112883923 | (37.7423077764783, -122.408112883923) | 10 | 7 | 7 | 28859 | 2 | |||
133854 | 248023 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 447 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6009976.04009 | 2098394.24313 | 37.7423538217629 | -122.408116309446 | (37.7423538217629, -122.408116309446) | 10 | 7 | 7 | 28859 | 2 | |||
83839 | 245276 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 211 Montcalm St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 2ft | 6009977.14888 | 2099657.76323 | 37.7458232344691 | -122.408201569656 | (37.7458232344691, -122.408201569656) | 2 | 7 | 7 | 28859 | 2 | |||
93526 | 245275 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 211 Montcalm St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 2ft | 6009973.05434 | 2099655.25827 | 37.7458161271257 | -122.408215551417 | (37.7458161271257, -122.408215551417) | 2 | 7 | 7 | 28859 | 2 | |||
61496 | 245274 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 211 Montcalm St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 2ft | 6009969.56038 | 2099653.89134 | 37.7458121781913 | -122.408227536697 | (37.7458121781913, -122.408227536697) | 2 | 7 | 7 | 28859 | 2 | |||
99748 | 245245 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 833 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | Permit Number 782335 | 6009947.06016 | 2104112.82939 | 37.7580541725802 | -122.408619834453 | (37.7580541725802, -122.408619834453) | 2 | 4 | 7 | 28859 | 19 | ||
147514 | 245244 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 833 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | Permit Number 782335 | 6009944.72353 | 2104090.22905 | 37.7579919862624 | -122.408626321254 | (37.7579919862624, -122.408626321254) | 2 | 4 | 7 | 28859 | 19 | ||
67165 | 258067 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 833 York St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x3 | Permit Number 782335 | 6009933.30187 | 2104364.32189 | 37.758743943813 | -122.408685158341 | (37.758743943813, -122.408685158341) | 2 | 4 | 7 | 28859 | 19 | |||
46815 | 245242 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 882 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6009904.77367 | 2104105.11232 | 37.7580306148353 | -122.408765535424 | (37.7580306148353, -122.408765535424) | 2 | 4 | 7 | 28859 | 19 | |||
58750 | 245241 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 882 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009904.02898 | 2104112.5978 | 37.7580511265686 | -122.408768638979 | (37.7580511265686, -122.408768638979) | 2 | 4 | 7 | 28859 | 19 | |||
42424 | 197761 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 7 | : | Tree | Private 2 | 7 | Width 3ft | 6010003.68567 | 2109694.36237 | 37.773382957679 | -122.408817777045 | (37.773382957679, -122.408817777045) | 14 | 2 | 9 | 28853 | 34 | |||
142415 | 245240 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 812 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009884.83098 | 2104450.7237 | 37.7589784688124 | -122.408858889543 | (37.7589784688124, -122.408858889543) | 2 | 4 | 7 | 28859 | 19 | |||
129611 | 63522 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 812 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1987 12:00:00 AM | Permit Number 24132 | 6009881.10701644 | 2104476.66274978 | 37.759049483001 | -122.4088735989 | (37.759049483001, -122.4088735989) | 2 | 4 | 7 | 28859 | 19 | ||
79981 | 197760 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | 6009984.84437 | 2109679.97053 | 37.773342385672 | -122.408881936452 | (37.773342385672, -122.408881936452) | 14 | 2 | 9 | 28853 | 34 | ||||
98061 | 100791 | Undocumented 4 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769131 | 6009961 | 2109679 | 37.773338385175 | -122.408964349313 | (37.773338385175, -122.408964349313) | 14 | 2 | 9 | 28853 | 34 | |
159492 | 100792 | Undocumented 4 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769131 | 6009961 | 2109679 | 37.773338385175 | -122.408964349313 | (37.773338385175, -122.408964349313) | 14 | 2 | 9 | 28853 | 34 | |
149495 | 197758 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6009958.32307 | 2109652.80645 | 37.7732663138222 | -122.408971760735 | (37.7732663138222, -122.408971760735) | 14 | 2 | 9 | 28853 | 34 | |||
133819 | 197757 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6009931.91498 | 2109631.18124 | 37.7732054566946 | -122.409061584123 | (37.7732054566946, -122.409061584123) | 14 | 2 | 9 | 28853 | 34 |
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) );