trees
8,758 rows where qSpecies_id = 16 sorted by SiteOrder descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
962 | 41611 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2285 Jerrold Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2002 12:00:00 AM | 6 | Permit Number 44542 | 6011801.95167 | 2099599.86034 | 37.7457662552178 | -122.401887553691 | (37.7457662552178, -122.401887553691) | 10 | 3 | 8 | 58 | 1 | |
1492 | 20444 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
2361 | 256460 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2901 Sunset Blvd | 9 | Median : Yard | Tree | Private 2 | 3x3 | 5984945 | 2095183 | 37.7321032922905 | -122.494428131787 | (37.7321032922905, -122.494428131787) | 1 | 8 | 4 | 64 | 35 | ||||
7630 | 24158 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 110X Whitney Young Cir | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6016346.0952597 | 2096044.1423309 | 37.736255534298 | -122.385926606914 | (37.736255534298, -122.385926606914) | 10 | 3 | 8 | 58 | 1 | |||
8555 | 77658 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6006705.39704 | 2093310.53877 | 37.7282114196192 | -122.419064719886 | (37.7282114196192, -122.419064719886) | 9 | 3 | 7 | 309 | 5 | ||
8940 | 119554 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601 30th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5986557.94783 | 2112181.99105 | 37.7788721422837 | -122.490101801894 | (37.7788721422837, -122.490101801894) | 11 | 6 | 2 | 55 | 26 | |||
11624 | 10949 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400X Hudson Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016738.0241541 | 2096692.24342 | 37.7380567715564 | -122.384616664641 | (37.7380567715564, -122.384616664641) | 10 | 3 | 8 | 58 | 1 | |||
13515 | 35181 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
13760 | 74588 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1335 Griffith St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6017904.0953 | 2092578.1569 | 37.7268247152753 | -122.380299097717 | (37.7268247152753, -122.380299097717) | 10 | 3 | 8 | 58 | 1 | |||
18983 | 262256 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4210 Ocean Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |||
19191 | 122767 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 86X Park Hill Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001171 | 2107689 | 37.7673780360046 | -122.439227450619 | (37.7673780360046, -122.439227450619) | 15 | 5 | 5 | 29492 | 3 | ||||
22408 | 140995 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2425 GEARY BLVD | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000038.2546 | 2113268.7849 | 37.7826341848066 | -122.443546313917 | (37.7826341848066, -122.443546313917) | 15 | 5 | 1 | 29490 | 16 | |||
23426 | 99331 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986581.6367 | 2112796.91447 | 37.7805619300043 | -122.490065095801 | (37.7805619300043, -122.490065095801) | 11 | 6 | 2 | 55 | 26 | ||
24089 | 231335 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 146 Alma St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997805.75576 | 2106190.70789 | 37.7630720343675 | -122.45075926683 | (37.7630720343675, -122.45075926683) | 15 | 5 | 11 | 29492 | 9 | |||
24109 | 183368 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3000 Quintara St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5983752.8923 | 2100895.2414 | 37.7477177160252 | -122.498971329101 | (37.7477177160252, -122.498971329101) | 1 | 8 | 3 | 29491 | 35 | |||
32170 | 5307 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1635 Divisadero St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6001124.6062 | 2113907.9724 | 37.7844511257674 | -122.439833854271 | (37.7844511257674, -122.439833854271) | 15 | 6 | 11 | 29490 | 13 | |||
41817 | 117812 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3900 Balboa St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5983395.26923 | 2111067.3725 | 37.7756265255914 | -122.500960129469 | (37.7756265255914, -122.500960129469) | 11 | 6 | 2 | 55 | 26 | |||
44200 | 8840 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4000 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 12 | M6 | 5994660.7719396 | 2112852.5225639 | 37.7811830898725 | -122.462119766821 | (37.7811830898725, -122.462119766821) | 11 | 6 | 2 | 54 | 11 | |||
45595 | 183233 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2001 37th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5984770.6958 | 2100914.193 | 37.747829401127 | -122.495453269303 | (37.747829401127, -122.495453269303) | 1 | 8 | 3 | 29491 | 35 | |||
45779 | 210407 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 900 Portola Dr | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996258.01148 | 2098872.85178 | 37.7428903204249 | -122.455583398467 | (37.7428903204249, -122.455583398467) | 1 | 7 | 4 | 59 | 40 | |||
45783 | 99671 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 150X Alma St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
46803 | 24102 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 105X Whitney Young Cir | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016397.2233978 | 2096041.081358 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | 10 | 3 | 8 | 58 | 1 | |||
49832 | 8949 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4800 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 12 | M6 | 5992178.808881 | 2112763.6040387 | 37.780795730088 | -122.470699570025 | (37.780795730088, -122.470699570025) | 11 | 6 | 2 | 54 | 11 | |||
53780 | 11895 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 604X Keith St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017303.30396 | 2096401.31923 | 37.7372891970298 | -122.382641953956 | (37.7372891970298, -122.382641953956) | 10 | 3 | 8 | 58 | 1 | |||
54131 | 209864 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 375 Parnassus Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995922.92875 | 2106407.01142 | 37.76355799022 | -122.457286934738 | (37.76355799022, -122.457286934738) | 15 | 5 | 4 | 29492 | 12 | |||
54513 | 20559 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1305X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10 | 5984811.9199471 | 2106303.0061321 | 37.7626280043626 | -122.495708151398 | (37.7626280043626, -122.495708151398) | 1 | 8 | 3 | 56 | 35 | |||
57747 | 24176 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101X Whitney Young Cir | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2001 12:00:00 AM | 6 | 5x3 | 6016616.57888 | 2095352.03883 | 37.7343701217881 | -122.384943221074 | (37.7343701217881, -122.384943221074) | 10 | 3 | 8 | 58 | 1 | ||
62323 | 131503 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 599 Turk St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6007492.04889 | 2112974.98665 | 37.7822497631524 | -122.417738482458 | (37.7822497631524, -122.417738482458) | 7 | 9 | 9 | 28852 | 36 | |||
63840 | 210312 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 374 Parnassus Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5995868.53746 | 2106449.83142 | 37.7636724388544 | -122.457478153996 | (37.7636724388544, -122.457478153996) | 15 | 5 | 11 | 29492 | 12 | |||
65334 | 114975 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 25 Point Lobos Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 3x3 | 5982783.76519 | 2112486.06679 | 37.7794859217892 | -122.503180498061 | (37.7794859217892, -122.503180498061) | 11 | 6 | 2 | 55 | 26 | |||
67344 | 184253 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3801 Kirkham St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 0ft | 5983040.9906 | 2104896.6867 | 37.758662782026 | -122.501729007539 | (37.758662782026, -122.501729007539) | 1 | 8 | 3 | 56 | 35 | |||
69105 | 143448 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 501 KEARNY ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6011467.1995 | 2116546.2911 | 37.7922786154557 | -122.404237594248 | (37.7922786154557, -122.404237594248) | 4 | 1 | 10 | 28854 | 6 | |||
70957 | 811 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600X 39th Ave | 9 | Median : Cutout | Tree | DPW 1 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | 11 | 6 | 2 | 55 | 26 | |||
72571 | 14437 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3X Masonic Ave | 9 | Median : Cutout | Tree | DPW 1 | 60 | 3X3 | 5998937.7460107 | 2113239.5974234 | 37.7824912190872 | -122.447351485422 | (37.7824912190872, -122.447351485422) | 15 | 5 | 2 | 54 | 16 | |||
73013 | 9221 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6300 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 12 | 8M | 5987257.696 | 2112564.9029 | 37.7799643479314 | -122.487709266059 | (37.7799643479314, -122.487709266059) | 11 | 6 | 2 | 55 | 26 | |||
73534 | 27067 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 801 Silver Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4 | 6006988.24058 | 2093612.55295 | 37.7290566087719 | -122.418108318754 | (37.7290566087719, -122.418108318754) | 9 | 3 | 7 | 309 | 28 | |||
73773 | 231799 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 65 Roosevelt Way | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001744.68694 | 2107473.6057 | 37.7668192449435 | -122.437227726473 | (37.7668192449435, -122.437227726473) | 15 | 5 | 5 | 28862 | 3 | |||
76946 | 20849 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1803X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5984917.6591811 | 2102927.8209446 | 37.7533668754054 | -122.495093546212 | (37.7533668754054, -122.495093546212) | 1 | 8 | 3 | 56 | 35 | |||
78975 | 131248 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2900 Divisadero St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6000566.6356 | 2118365.98432 | 37.7966598871931 | -122.442084343421 | (37.7966598871931, -122.442084343421) | 13 | 9 | 1 | 57 | 17 | |||
81068 | 177657 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Wheeler Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011903.43858 | 2086633.42033 | 37.710168753063 | -122.400625914559 | (37.710168753063, -122.400625914559) | 10 | 3 | 8 | 309 | 1 | |||
82952 | 213277 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 Holloway Ave | 9 | : | Tree | Private 2 | 9 | Width 0ft | 5991091.24453 | 2091195.38436 | 37.7215120845989 | -122.472888754009 | (37.7215120845989, -122.472888754009) | 9 | 8 | 4 | 64 | 40 | |||
85021 | 186528 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501 Sunset Blvd | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984787.1073 | 2104437.5473 | 37.7575045220907 | -122.495656364603 | (37.7575045220907, -122.495656364603) | 1 | 8 | 3 | 56 | 35 | |||
87103 | 14421 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Masonic Ave | 9 | Median : Cutout | Tree | DPW 1 | 90 | 3X3 | 5998843.9665 | 2113055.4136 | 37.7819801389805 | -122.447662657424 | (37.7819801389805, -122.447662657424) | 15 | 5 | 2 | 54 | 16 | |||
89874 | 124198 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Rossi Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996310.06451 | 2111872.62247 | 37.7785873647191 | -122.456343191663 | (37.7785873647191, -122.456343191663) | 11 | 6 | 2 | 54 | 16 | |||
91994 | 21057 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2103X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5984987.6230273 | 2100889.8482373 | 37.7477752566644 | -122.494701361992 | (37.7477752566644, -122.494701361992) | 1 | 8 | 3 | 29491 | 35 | |||
99604 | 20796 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1703X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5984905.3324351 | 2103602.9558617 | 37.7552198878299 | -122.495185956691 | (37.7552198878299, -122.495185956691) | 1 | 8 | 3 | 56 | 35 | |||
101825 | 97903 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 375X Precita Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | 3x3 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | 2 | 7 | 7 | 28859 | 2 | ||
102102 | 231287 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 357 Precita Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008812.86464 | 2100219.81382 | 37.7473012387592 | -122.412267231967 | (37.7473012387592, -122.412267231967) | 2 | 7 | 7 | 28859 | 2 | |||
102963 | 231422 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2291 Harrison St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008813.53919 | 2105287.80048 | 37.7612168256216 | -122.412623108097 | (37.7612168256216, -122.412623108097) | 2 | 4 | 7 | 28859 | 19 | |||
104708 | 186332 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1801 37th Ave | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 0ft | 5984861.764 | 2102396.6124 | 37.7519050505616 | -122.495247669454 | (37.7519050505616, -122.495247669454) | 1 | 8 | 3 | 56 | 35 | |||
105433 | 193841 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Barneveld Ave | 9 | : | Tree | Private 2 | 2 | Width 3ft | 6011580.56119 | 2099671.3344 | 37.7459501494982 | -122.402658119778 | (37.7459501494982, -122.402658119778) | 10 | 3 | 8 | 58 | 1 | |||
107456 | 186508 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 Lower Great Hwy | 9 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5980903.4565 | 2105112.4796 | 37.7591295006299 | -122.509137465432 | (37.7591295006299, -122.509137465432) | 1 | 8 | 3 | 56 | 35 | |||
111825 | 46934 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 29 Rockaway Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44982 | 5995921.53864707 | 2099025.2033151 | 37.7432893260314 | -122.456757836773 | (37.7432893260314, -122.456757836773) | 1 | 8 | 4 | 59 | 40 | |||
115408 | 99355 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 3x3 | 5986839.02344 | 2113010.76146 | 37.7811641198035 | -122.489190411627 | (37.7811641198035, -122.489190411627) | 11 | 6 | 2 | 55 | 26 | ||
119088 | 141211 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3333 CALIFORNIA ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998545.2247 | 2114861.6554 | 37.7869225276918 | -122.44882630578 | (37.7869225276918, -122.44882630578) | 15 | 6 | 1 | 54 | 31 | |||
119983 | 131638 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 John Maher St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6012504.601 | 2119700.39069 | 37.800996931627 | -122.40086983947 | (37.800996931627, -122.40086983947) | 3 | 1 | 10 | 28860 | 6 | |||
120556 | 16260 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 625 Monterey Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5997965.29336 | 2094665.68979 | 37.7314362868584 | -122.449377059203 | (37.7314362868584, -122.449377059203) | 9 | 7 | 4 | 59 | 40 | |||
122094 | 25328 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 755 Ocean Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5998159.44137 | 2091531.27047 | 37.7228410113819 | -122.448480208308 | (37.7228410113819, -122.448480208308) | 9 | 7 | 4 | 28861 | 24 | |||
122266 | 48610 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201 Ulloa St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45914 | 5996181.58703013 | 2099061.98037763 | 37.7434052350482 | -122.455861320442 | (37.7434052350482, -122.455861320442) | 1 | 5 | 4 | 59 | 40 | ||
125375 | 19561 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 399X Saint Joseph's Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6000237.59521 | 2113336.21742 | 37.7828307037077 | -122.442861526711 | (37.7828307037077, -122.442861526711) | 15 | 5 | 1 | 29490 | 16 | |||
129115 | 139339 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1599 Post St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6004846.5078 | 2114344.6331 | 37.7858612422876 | -122.426988458759 | (37.7858612422876, -122.426988458759) | 13 | 9 | 11 | 28858 | 13 | |||
129736 | 210457 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 755 Ocean Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 4ft | 5998163.59048 | 2091528.92659 | 37.722834812863 | -122.448465697057 | (37.722834812863, -122.448465697057) | 9 | 7 | 4 | 28861 | 24 | |||
131443 | 131478 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 455 Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6007504.16333 | 2112632.21323 | 37.7813092719381 | -122.417672268963 | (37.7813092719381, -122.417672268963) | 7 | 9 | 9 | 28852 | 36 | |||
131578 | 183125 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2335 41st Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5983586.3436 | 2099288.5588 | 37.7432964362409 | -122.499428521102 | (37.7432964362409, -122.499428521102) | 1 | 8 | 3 | 29491 | 35 | |||
132429 | 177662 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 500 Mansell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6010066.89323 | 2090287.31242 | 37.7200989942621 | -122.40723081537 | (37.7200989942621, -122.40723081537) | 10 | 3 | 7 | 309 | 28 | |||
134062 | 193906 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 151 Berry St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6014742.62847 | 2110682.85883 | 37.7763614466609 | -122.392494132225 | (37.7763614466609, -122.392494132225) | 6 | 2 | 9 | 28856 | 20 | |||
134652 | 3155 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3395X California St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3.5x5 | 5998207.526573 | 2114818.376913 | 37.78678437906 | -122.449991538327 | (37.78678437906, -122.449991538327) | 15 | 6 | 1 | 54 | 31 | |||
135079 | 35228 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2559 40th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1998 12:00:00 AM | Permit Number 38723 | 5983945.81332692 | 2097751.53443122 | 37.7390972690525 | -122.49807210272 | (37.7390972690525, -122.49807210272) | 1 | 8 | 3 | 29491 | 35 | ||
140899 | 19552 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300X Saint Joseph's Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000579.8735828 | 2113139.7164613 | 37.7823106701496 | -122.441663283894 | (37.7823106701496, -122.441663283894) | 15 | 5 | 1 | 29490 | 41 | |||
144293 | 95146 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4055X Geary Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3x3 | 5994484.64033 | 2112777.49176 | 37.7809669329485 | -122.462723645683 | (37.7809669329485, -122.462723645683) | 11 | 6 | 2 | 54 | 11 | |||
147650 | 13383 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1000X Mansell St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 3X3 | 6008956.7805816 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | 9 | 7 | 7 | 309 | 18 | |||
147914 | 18125 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 Portola Dr | 9 | Median : Cutout | Tree | DPW 1 | 6 | 10 | 5992881.81399 | 2097305.58715 | 37.7383926876616 | -122.467143324498 | (37.7383926876616, -122.467143324498) | 1 | 8 | 4 | 59 | 40 | |||
148154 | 183075 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2626 42nd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5983397.4685 | 2096994.0855 | 37.7369853546466 | -122.49991202573 | (37.7369853546466, -122.49991202573) | 1 | 8 | 3 | 29491 | 35 | |||
149298 | 95153 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 250 23rd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 5988721.45224 | 2113658.22406 | 37.783051567455 | -122.482725682991 | (37.783051567455, -122.482725682991) | 11 | 6 | 2 | 55 | 26 | |||
153746 | 250050 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Daniel Burnham Ct | 9 | : | Tree | Private 2 | 11 | Width 3ft | 6005954.34563 | 2114709.51335 | 37.7869256936999 | -122.423181588678 | (37.7869256936999, -122.423181588678) | 13 | 9 | 1 | 28858 | 41 | |||
155807 | 10917 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1351X Hudson Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/16/1997 12:00:00 AM | 6 | 3X4 | 6017006.20214 | 2096054.42472 | 37.7363202764463 | -122.383645037995 | (37.7363202764463, -122.383645037995) | 10 | 3 | 8 | 58 | 1 | ||
155953 | 5025 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5320 Diamond Heights Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/1992 12:00:00 AM | 3 | 2X2 | 6001712.94606 | 2098728.75979 | 37.7428061969501 | -122.436711473383 | (37.7428061969501, -122.436711473383) | 2 | 7 | 5 | 63 | 7 | ||
159264 | 131356 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2501 Jackson St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001584.13998 | 2116615.83989 | 37.7919123795925 | -122.43843810243 | (37.7919123795925, -122.43843810243) | 13 | 6 | 1 | 29490 | 27 | |||
165788 | 18136 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400X Portola Dr | 9 | Median : Cutout | Tree | DPW 1 | 18 | 10 | 5993139.2629046 | 2097621.4275272 | 37.7392747636088 | -122.466276146282 | (37.7392747636088, -122.466276146282) | 1 | 8 | 4 | 59 | 40 | |||
167368 | 118925 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 855 La Playa | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5980744.81689 | 2109798.23147 | 37.7719858593014 | -122.510034219696 | (37.7719858593014, -122.510034219696) | 11 | 6 | 2 | 55 | 26 | |||
168468 | 231459 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1301 Douglass St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001381.66954 | 2099922.27345 | 37.7460644712911 | -122.43794240154 | (37.7460644712911, -122.43794240154) | 2 | 4 | 5 | 63 | 22 | |||
168752 | 141504 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 501 PARKER AVE | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997185.1085 | 2111176.4959 | 37.7767261774122 | -122.45326582617 | (37.7767261774122, -122.45326582617) | 15 | 6 | 2 | 54 | 16 | |||
170731 | 184241 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1560 43rd Ave | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5982820.835 | 2104772.4768 | 37.7583088027406 | -122.502481200295 | (37.7583088027406, -122.502481200295) | 1 | 8 | 3 | 56 | 35 | |||
170890 | 39238 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1998 12:00:00 AM | 5 | Permit Number 40872 | 6007339.74638 | 2112660.81764 | 37.7813785593161 | -122.418243101041 | (37.7813785593161, -122.418243101041) | 7 | 9 | 9 | 28852 | 36 | ||
171291 | 76271 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3899X Kirkham St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/14/1994 12:00:00 AM | 8 | 3x20 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 | |
172052 | 185372 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2900 Wawona St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5983789.4975 | 2096821.8757 | 37.7365355115304 | -122.498543910586 | (37.7365355115304, -122.498543910586) | 1 | 8 | 3 | 29491 | 35 | |||
172116 | 102982 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
173664 | 131616 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 North Point St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008985.35955 | 2121850.72044 | 37.8067042721502 | -122.413200103225 | (37.8067042721502, -122.413200103225) | 3 | 1 | 10 | 308 | 23 | |||
173818 | 177790 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Cordova St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6002013.3907 | 2086792.75344 | 37.7100496963121 | -122.434819239526 | (37.7100496963121, -122.434819239526) | 9 | 7 | 6 | 28861 | 5 | |||
174594 | 183020 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3901 Ulloa St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5983906.2618 | 2098121.8504 | 37.7401117372444 | -122.498236194383 | (37.7401117372444, -122.498236194383) | 1 | 8 | 3 | 29491 | 35 | |||
175328 | 8869 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4141 Geary Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 5994273.03494 | 2112763.41728 | 37.7809160988256 | -122.463454665981 | (37.7809160988256, -122.463454665981) | 11 | 6 | 2 | 54 | 11 | |||
176013 | 114604 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 IRVING ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995817 | 2106753 | 37.7645019012702 | -122.457678342592 | (37.7645019012702, -122.457678342592) | 15 | 5 | 11 | 56 | 12 | ||||
176178 | 282 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3250 19th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 2 | 5990676.28121 | 2094101.04473 | 37.7294662695904 | -122.474535101923 | (37.7294662695904, -122.474535101923) | 9 | 8 | 4 | 64 | 40 | |||
177608 | 113816 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4101x 25TH ST | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 10 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
178867 | 91182 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Polk St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007496.395175 | 2110885.881534 | 37.7765138277066 | -122.41757533494 | (37.7765138277066, -122.41757533494) | 7 | 2 | 9 | 28852 | 36 | |||
186291 | 38742 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
189692 | 210385 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 220 Ulloa St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996121.53491 | 2098983.02288 | 37.74318499051 | -122.456063256942 | (37.74318499051, -122.456063256942) | 1 | 8 | 4 | 59 | 40 | |||
190286 | 43960 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2700 Sloat Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2000 12:00:00 AM | Permit Number 43533 | 5982473.74529439 | 2096486.33377202 | 37.7355369547755 | -122.503068116639 | (37.7355369547755, -122.503068116639) | 1 | 8 | 3 | 29491 | 35 | |||
191209 | 139703 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 319 Saint Joseph's Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000441.6999 | 2113146.7863 | 37.7823222086005 | -122.442141809842 | (37.7823222086005, -122.442141809842) | 15 | 5 | 1 | 29490 | 16 | |||
192551 | 232558 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 665 Elizabeth St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002164.87583 | 2102045.53482 | 37.7519389517211 | -122.435386037248 | (37.7519389517211, -122.435386037248) | 2 | 4 | 5 | 28862 | 22 |
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) );