Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
87727 | 87727 | 65566 | Permitted Site 1 | Tree(s) :: 17 | 340 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/1990 12:00:00 AM | Permit Number 28465 | 6022030.55852908 | 2122617.11164597 | 37.8095323316173 | -122.368107024455 | (37.8095323316173, -122.368107024455) | |||
143067 | 143067 | 65565 | Permitted Site 1 | Tree(s) :: 17 | 282 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/1990 12:00:00 AM | Permit Number 28464 | 6022001.13211196 | 2122805.77301993 | 37.8100487398864 | -122.368221901586 | (37.8100487398864, -122.368221901586) | |||
2371 | 2371 | 253059 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 421 Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770411 | 6021349.4 | 2093117.8080000002 | 37.728495991679296 | -122.368425863032 | (37.7284959916793, -122.368425863032) | ||
2385 | 2385 | 253058 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 421 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770411 | 6021349.4 | 2093117.8080000002 | 37.728495991679296 | -122.368425863032 | (37.7284959916793, -122.368425863032) | ||
2395 | 2395 | 253061 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 421 Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770411 | 6021349.4 | 2093117.8080000002 | 37.728495991679296 | -122.368425863032 | (37.7284959916793, -122.368425863032) | ||
2462 | 2462 | 253060 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 421 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770411 | 6021349.4 | 2093117.8080000002 | 37.728495991679296 | -122.368425863032 | (37.7284959916793, -122.368425863032) | ||
2365 | 2365 | 253069 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
2380 | 2380 | 253068 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
2382 | 2382 | 253067 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
2384 | 2384 | 253066 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
2373 | 2373 | 253062 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 451 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770412 | 6021215.947000001 | 2093217.369 | 37.728762049698204 | -122.36889409743 | (37.7287620496982, -122.36889409743) | ||
2421 | 2421 | 253064 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 451 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770412 | 6021215.947000001 | 2093217.369 | 37.728762049698204 | -122.36889409743 | (37.7287620496982, -122.36889409743) | ||
2431 | 2431 | 253063 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 451 Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770412 | 6021215.947000001 | 2093217.369 | 37.728762049698204 | -122.36889409743 | (37.7287620496982, -122.36889409743) | ||
90246 | 90246 | 65563 | Permitted Site 1 | Tree(s) :: 17 | 255 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/1990 12:00:00 AM | Permit Number 28462 | 6021766.42970205 | 2122905.90070123 | 37.8103107984086 | -122.36904110347099 | (37.8103107984086, -122.369041103471) | |||
2405 | 2405 | 201816 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021143.08428 | 2093327.21502 | 37.729059670062206 | -122.36915357747299 | (37.7290596700622, -122.369153577473) | ||
2369 | 2369 | 201815 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021129.2467 | 2093308.19399 | 37.7290066829092 | -122.369200102111 | (37.7290066829092, -122.369200102111) | ||
2391 | 2391 | 201814 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021112.10587 | 2093285.4865 | 37.728943392223 | -122.36925779181699 | (37.728943392223, -122.369257791817) | ||
2466 | 2466 | 201813 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021086.18405 | 2093254.37787 | 37.728856551886395 | -122.369345258092 | (37.7288565518864, -122.369345258092) | ||
2367 | 2367 | 253057 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6021055.26176 | 2093480.52839 | 37.729475822337605 | -122.36946777993099 | (37.7294758223376, -122.369467779931) | |
2386 | 2386 | 201590 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6021055.26176 | 2093480.52839 | 37.729475822337605 | -122.36946777993099 | (37.7294758223376, -122.369467779931) | |
2455 | 2455 | 201589 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6021039.89306 | 2093459.94557 | 37.729418462686894 | -122.369519490027 | (37.7294184626869, -122.369519490027) | |
2374 | 2374 | 201588 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6021025.00287 | 2093440.1386 | 37.7293632596022 | -122.369569599359 | (37.7293632596022, -122.369569599359) | |
2389 | 2389 | 201587 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6021008.9496 | 2093419.1731599998 | 37.729304811746104 | -122.36962364951799 | (37.7293048117461, -122.369623649518) | |
2403 | 2403 | 201586 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020998.06283 | 2093403.93478 | 37.729262372745794 | -122.36966023392799 | (37.7292623727458, -122.369660233928) | |
2460 | 2460 | 201825 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 232 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020928.29141 | 2093111.1924700001 | 37.7284547293849 | -122.36988121894899 | (37.7284547293849, -122.369881218949) | |
93209 | 93209 | 65564 | Permitted Site 1 | Tree(s) :: 17 | 228 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/1990 12:00:00 AM | Permit Number 28463 | 6021524.08705829 | 2122941.38889516 | 37.8103949467147 | -122.36988228287599 | (37.8103949467147, -122.369882282876) | |||
2433 | 2433 | 201610 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 599 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 770566 | 6020924.70462 | 2093166.9470099998 | 37.7286076240414 | -122.36989747059201 | (37.7286076240414, -122.369897470592) | |
2422 | 2422 | 201585 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020918.10936 | 2093291.5638700002 | 37.728949436562 | -122.36992888032302 | (37.728949436562, -122.369928880323) | |
2435 | 2435 | 201826 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 250 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020898.42083 | 2093071.04954 | 37.7283428654122 | -122.369981710984 | (37.7283428654122, -122.369981710984) | |
2446 | 2446 | 201827 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 258 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020879.65439 | 2093047.83852 | 37.7282781025329 | -122.370044984594 | (37.7282781025329, -122.370044984594) | |
2392 | 2392 | 253051 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
2397 | 2397 | 253052 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
2413 | 2413 | 253048 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
2414 | 2414 | 253049 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
2448 | 2448 | 253050 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
2464 | 2464 | 253053 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
2444 | 2444 | 201828 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 268 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020862.97624 | 2093021.3694799999 | 37.728204508308 | -122.3701008136 | (37.728204508308, -122.3701008136) | |
2406 | 2406 | 201829 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 284 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020846.41585 | 2093000.7945400001 | 37.7281471046068 | -122.37015664263399 | (37.7281471046068, -122.370156642634) | |
2423 | 2423 | 201830 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 292 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020827.60649 | 2092975.44043 | 37.7280764547545 | -122.370219916224 | (37.7280764547545, -122.370219916224) | |
2412 | 2412 | 201597 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020830.52372 | 2093183.4296400002 | 37.728647714022 | -122.37022420239201 | (37.728647714022, -122.370224202392) | |
2415 | 2415 | 201596 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020816.91369 | 2093164.12057 | 37.7285939480275 | -122.370269919443 | (37.7285939480275, -122.370269919443) | |
2376 | 2376 | 201595 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020802.701169999 | 2093144.94147 | 37.7285405058214 | -122.370317728275 | (37.7285405058214, -122.370317728275) | |
2377 | 2377 | 201594 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020788.86166 | 2093125.8535099998 | 37.7284873343211 | -122.370364253806 | (37.7284873343211, -122.370364253806) | |
2411 | 2411 | 201831 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020768.36275 | 2092897.8842900002 | 37.7278602487283 | -122.37041936696698 | (37.7278602487283, -122.370419366967) | |
2447 | 2447 | 201593 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020771.25022 | 2093102.78815 | 37.72842303458621 | -122.370423544329 | (37.7284230345862, -122.370423544329) | |
2393 | 2393 | 201592 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020757.80811 | 2093085.24603 | 37.7283741294404 | -122.370468802689 | (37.7283741294404, -122.370468802689) | |
2390 | 2390 | 201832 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020752.62591 | 2092874.74971 | 37.727795861786205 | -122.370472171548 | (37.7277958617862, -122.370472171548) | |
2437 | 2437 | 201591 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020744.06411 | 2093067.1780599998 | 37.7283237638216 | -122.37051506831001 | (37.7283237638216, -122.37051506831) | |
2454 | 2454 | 201833 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020733.63229 | 2092847.8779900002 | 37.727721034575296 | -122.370535976659 | (37.7277210345753, -122.370535976659) | |
2362 | 2362 | 201584 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020732.46705 | 2093049.56763 | 37.7282747723482 | -122.370553943333 | (37.7282747723482, -122.370553943333) | |
2461 | 2461 | 201834 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020718.56969 | 2092826.63123 | 37.7276618681873 | -122.37058658062 | (37.7276618681873, -122.37058658062) | |
2419 | 2419 | 201835 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020706.7385 | 2092807.85492 | 37.72760966254629 | -122.370626184075 | (37.7276096625463, -122.370626184075) | |
2372 | 2372 | 201583 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020706.31037 | 2093011.12913 | 37.7281677917075 | -122.370641712658 | (37.7281677917075, -122.370641712658) | |
2453 | 2453 | 201836 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020688.4191 | 2092782.87071 | 37.7275400550072 | -122.370687788509 | (37.7275400550072, -122.370687788509) | |
2452 | 2452 | 201837 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020676.58787 | 2092764.09442 | 37.7274878493838 | -122.370727391967 | (37.7274878493838, -122.370727391967) | |
2400 | 2400 | 201838 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020663.4716 | 2092744.71005 | 37.7274339035298 | -122.37077139578501 | (37.7274339035298, -122.370771395785) | |
2456 | 2456 | 201598 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 98 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020624.74965 | 2092745.3424200001 | 37.7274335141325 | -122.370905303063 | (37.7274335141325, -122.370905303063) | |
2441 | 2441 | 201599 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 98 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020607.895690001 | 2092757.2128700002 | 37.72746518285071 | -122.37096438849899 | (37.7274651828507, -122.370964388499) | |
2430 | 2430 | 201600 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 98 Kirkwood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020594.26008 | 2092766.53995 | 37.7274900446232 | -122.371012172182 | (37.7274900446232, -122.371012172182) | |
80292 | 80292 | 93212 | Permitted Site 1 | Tree(s) :: 17 | 655 Innes Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.729376996017606 | -122.371154647854 | (37.7293769960176, -122.371154647854) | ||
81510 | 81510 | 93211 | Permitted Site 1 | Tree(s) :: 17 | 655 Innes Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.729376996017606 | -122.371154647854 | (37.7293769960176, -122.371154647854) | ||
84352 | 84352 | 93214 | Permitted Site 1 | Tree(s) :: 17 | 655 Innes Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.729376996017606 | -122.371154647854 | (37.7293769960176, -122.371154647854) | ||
99680 | 99680 | 93208 | Permitted Site 1 | Tree(s) :: 17 | 655 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.729376996017606 | -122.371154647854 | (37.7293769960176, -122.371154647854) | ||
111669 | 111669 | 93209 | Permitted Site 1 | Tree(s) :: 17 | 655 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.729376996017606 | -122.371154647854 | (37.7293769960176, -122.371154647854) | ||
113795 | 113795 | 93213 | Permitted Site 1 | Tree(s) :: 17 | 655 Innes Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.729376996017606 | -122.371154647854 | (37.7293769960176, -122.371154647854) | ||
146160 | 146160 | 93210 | Permitted Site 1 | Tree(s) :: 17 | 655 Innes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.729376996017606 | -122.371154647854 | (37.7293769960176, -122.371154647854) | ||
82128 | 82128 | 39988 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 702 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | Permit Number 41246 | 6020313.39222717 | 2093680.55714076 | 37.729984337867705 | -122.37204636190701 | (37.7299843378677, -122.372046361907) | ||
53060 | 53060 | 39989 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 710 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 12 | Permit Number 41247 | 6020263.29136 | 2093725.43573 | 37.73010481357829 | -122.372222673141 | (37.7301048135783, -122.372222673141) | |
73500 | 73500 | 39990 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 714 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 10 | Permit Number 41248 | 6020251.6051199995 | 2093735.0931099998 | 37.730130688869295 | -122.372263742486 | (37.7301306888693, -122.372263742486) | |
51306 | 51306 | 39991 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 724 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 10 | Permit Number 41249 | 6020211.31416 | 2093764.16933 | 37.730208312959995 | -122.372405046655 | (37.73020831296, -122.372405046655) | |
181388 | 181388 | 39992 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 744 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 10 | Permit Number 41250 | 6020175.81777 | 2093790.38567 | 37.7302783476475 | -122.372529577584 | (37.7302783476475, -122.372529577584) | |
55574 | 55574 | 194005 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 900 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6019962.69863 | 2093253.82353 | 37.728793337639296 | -122.373229233067 | (37.7287933376393, -122.373229233067) | |||
157235 | 157235 | 194006 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 900 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6019953.97455 | 2093259.9764900003 | 37.7288097529433 | -122.37325981899099 | (37.7288097529433, -122.373259818991) | |||
56492 | 56492 | 112098 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729x Kirkwood Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6019849.108630001 | 2093255.57368 | 37.7287918987073 | -122.373622047041 | (37.7287918987073, -122.373622047041) | |||
41705 | 41705 | 112097 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729x Kirkwood Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6019796.6756 | 2093294.4131599998 | 37.7288956616077 | -122.373806002468 | (37.7288956616077, -122.373806002468) | |||
35495 | 35495 | 112096 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729x Kirkwood Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6019785.67464 | 2093301.20525 | 37.7289137064936 | -122.373844504239 | (37.7289137064936, -122.373844504239) | |||
160216 | 160216 | 112095 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729x Kirkwood Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6019776.75141 | 2093308.7775 | 37.7289340077863 | -122.373875877092 | (37.7289340077863, -122.373875877092) | |||
77552 | 77552 | 50767 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Innes Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | Permit Number 47301 | 6019786.72970778 | 2094070.44918577 | 37.73102596117 | -122.373894113437 | (37.73102596117, -122.373894113437) | |||
81095 | 81095 | 50764 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Innes Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | Permit Number 47301 | 6019786.72970778 | 2094070.44918577 | 37.73102596117 | -122.373894113437 | (37.73102596117, -122.373894113437) | |||
142095 | 142095 | 50766 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Innes Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | Permit Number 47301 | 6019786.72970778 | 2094070.44918577 | 37.73102596117 | -122.373894113437 | (37.73102596117, -122.373894113437) | |||
143984 | 143984 | 50765 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Innes Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | Permit Number 47301 | 6019786.72970778 | 2094070.44918577 | 37.73102596117 | -122.373894113437 | (37.73102596117, -122.373894113437) | |||
132560 | 132560 | 112094 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729x Kirkwood Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6019767.42453 | 2093316.7688799999 | 37.7289554377256 | -122.37390867444401 | (37.7289554377256, -122.373908674444) | |||
170529 | 170529 | 112093 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729x Kirkwood Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6019760.126019999 | 2093323.07612 | 37.7289723548671 | -122.373934342906 | (37.7289723548671, -122.373934342906) | |||
152971 | 152971 | 112092 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729x Kirkwood Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6019748.33316 | 2093331.52762 | 37.728994912587105 | -122.373975697329 | (37.7289949125871, -122.373975697329) | |||
175526 | 175526 | 50769 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | 5 | Permit Number 47301 | 6019759.98299 | 2094100.60005 | 37.7311072788765 | -122.373988670067 | (37.7311072788765, -122.373988670067) | ||
73047 | 73047 | 112091 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729x Kirkwood Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6019736.09499 | 2093338.3445099997 | 37.729012957477295 | -122.37401847808901 | (37.7290129574773, -122.374018478089) | |||
147101 | 147101 | 50770 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | 5 | Permit Number 47301 | 6019742.9176 | 2094113.11365 | 37.7311407003688 | -122.374048535228 | (37.7311407003688, -122.374048535228) | ||
163408 | 163408 | 112090 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729x Kirkwood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6019725.52267 | 2093345.9498 | 37.7290332587574 | -122.374055554419 | (37.7290332587574, -122.374055554419) | |||
169783 | 169783 | 112089 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729x Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6019713.35879 | 2093356.4623200002 | 37.7290614551979 | -122.37409833427799 | (37.7290614551979, -122.374098334278) | |||
123411 | 123411 | 50768 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800 Innes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | 5 | Permit Number 47301 | 6019728.52002 | 2094123.20714 | 37.7311676233867 | -122.374099009669 | (37.7311676233867, -122.374099009669) | ||
66229 | 66229 | 112088 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729x Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6019699.12491 | 2093366.60559 | 37.729088523892706 | -122.37414824484199 | (37.7290885238927, -122.374148244842) | |||
33756 | 33756 | 44524 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 828 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2001 12:00:00 AM | 7 | Permit Number 43824 | 6019592.367330001 | 2094224.8297299999 | 37.73143917097 | -122.37457675743799 | (37.73143917097, -122.374576757438) | ||
65032 | 65032 | 44522 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 828 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2001 12:00:00 AM | 7 | Permit Number 43824 | 6019580.98035 | 2094232.6652900001 | 37.731460059529795 | -122.37461666754601 | (37.7314600595298, -122.374616667546) | ||
61890 | 61890 | 44521 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 828 Innes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2001 12:00:00 AM | 7 | Permit Number 43824 | 6019557.73451 | 2094250.2049099999 | 37.731506941191 | -122.37469824864999 | (37.731506941191, -122.37469824865) | ||
53030 | 53030 | 44523 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 828 Innes Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2001 12:00:00 AM | 6 | Permit Number 43824 | 6019546.1676 | 2094257.53708 | 37.7315264375989 | -122.37473874602101 | (37.7315264375989, -122.374738746021) | ||
132075 | 132075 | 39994 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 863 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2005 12:00:00 AM | 12 | 3x3 | Permit Number 41252 | 6019434.68731 | 2094262.5096 | 37.731533957726796 | -122.375124503897 | (37.7315339577268, -122.375124503897) |
131343 | 131343 | 39995 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 869 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2004 12:00:00 AM | 6 | 3x3 | Permit Number 47551 | 6019405.77873 | 2094282.05396 | 37.7315860320638 | -122.375225801726 | (37.7315860320638, -122.375225801726) |
166526 | 166526 | 39997 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 871 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 5 | Permit Number 41255 | 6019390.137999999 | 2094293.5520799998 | 37.731616743009795 | -122.375280672083 | (37.7316167430098, -122.375280672083) | |
163542 | 163542 | 40000 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 881 Innes Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 14 | Permit Number 41257 | 6019376.91864 | 2094304.0292599997 | 37.7316447838739 | -122.375327100491 | (37.7316447838739, -122.375327100491) | |
167480 | 167480 | 40003 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 881 Innes Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 8 | Permit Number 41257 | 6019368.47353 | 2094309.06128 | 37.7316581360927 | -122.375356645916 | (37.7316581360927, -122.375356645916) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");