trees
3,267 rows where qSpecies_id = 67 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1578 | 10783 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1200X Hudson Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x4 | 6017715.9911991 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | 10 | 3 | 8 | 58 | 1 | |||
3736 | 38554 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1791 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 6 | Permit Number 40521 | 6014548.21389 | 2096859.31136 | 37.7383941607708 | -122.392199668106 | (37.7383941607708, -122.392199668106) | 10 | 3 | 8 | 58 | 1 | |
6333 | 189017 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1715 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014919.07097 | 2096583.11887 | 37.7376563776397 | -122.390898117058 | (37.7376563776397, -122.390898117058) | 10 | 3 | 8 | 58 | 1 | |||
7081 | 199881 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1411 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6015892.5426 | 2093410.4263 | 37.7289987677543 | -122.387311077708 | (37.7289987677543, -122.387311077708) | 10 | 3 | 8 | 58 | 1 | |||
7645 | 56389 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1338 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 14 | Permit Number 12542 | 6016160.8061 | 2092941.1028 | 37.7277249515347 | -122.386350953513 | (37.7277249515347, -122.386350953513) | 10 | 3 | 8 | 58 | 1 | ||
7769 | 199923 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1398 Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6017238.3952 | 2092867.7981 | 37.7275832604461 | -122.382620574427 | (37.7275832604461, -122.382620574427) | 10 | 3 | 8 | 58 | 1 | |||
8896 | 56726 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1523 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Permit Number 769408 | 6015773.2097 | 2095596.9346 | 37.7349958716637 | -122.387876131204 | (37.7349958716637, -122.387876131204) | 10 | 3 | 8 | 58 | 1 | |||
9504 | 74038 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1501 25th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014092.75077 | 2101968.09189 | 37.7523964980076 | -122.394132008099 | (37.7523964980076, -122.394132008099) | 10 | 3 | 8 | 28856 | 1 | |||
9642 | 53732 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 145 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/1972 12:00:00 AM | 11 | 3x3 | Permit Number 9411 | 6012636.58641 | 2095202.58654 | 37.7337388121015 | -122.398692955821 | (37.7337388121015, -122.398692955821) | 10 | 3 | 8 | 58 | 1 | |
10062 | 199899 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1829 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6015967.4581 | 2093314.0277 | 37.7287382249947 | -122.387045366056 | (37.7287382249947, -122.387045366056) | 10 | 3 | 8 | 58 | 1 | |||
10420 | 105551 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1398X HAWES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6017214 | 2092838 | 37.7275000929711 | -122.382702837059 | (37.7275000929711, -122.382702837059) | 10 | 3 | 8 | 58 | 1 | |||
10973 | 10788 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1200X Hudson Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x4 | 6017715.9911991 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | 10 | 3 | 8 | 58 | 1 | |||
11604 | 54558 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 50 Maddux Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1972 12:00:00 AM | 8 | Permit Number 10353 | 6012731.08144 | 2095469.91543 | 37.7344781060868 | -122.398385007285 | (37.7344781060868, -122.398385007285) | 10 | 3 | 8 | 58 | 1 | ||
13274 | 188254 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6013780.02718 | 2089753.49239 | 37.7188403408752 | -122.39435831441 | (37.7188403408752, -122.39435831441) | 10 | 3 | 8 | 58 | 1 | ||||
14798 | 199912 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1319 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6016381.1458 | 2093047.4167 | 37.728029062608 | -122.385596634641 | (37.728029062608, -122.385596634641) | 10 | 3 | 8 | 58 | 1 | |||
14853 | 188956 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1706 La Salle Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6014961.30392 | 2096622.74747 | 37.7377675329349 | -122.390754864938 | (37.7377675329349, -122.390754864938) | 10 | 3 | 8 | 58 | 1 | |||
15573 | 10975 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1468X Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016410.2814628 | 2096936.3836856 | 37.7387090009717 | -122.385766856192 | (37.7387090009717, -122.385766856192) | 10 | 3 | 8 | 58 | 1 | |||
15816 | 26895 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1245X Lane St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4 | 6015870.9547371 | 2095407.1210845 | 37.7344800964063 | -122.387524951 | (37.7344800964063, -122.387524951) | 10 | 3 | 8 | 58 | 1 | |||
17440 | 188953 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1723 La Salle Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014879.29111 | 2096612.07207 | 37.7377336698595 | -122.391037679267 | (37.7377336698595, -122.391037679267) | 10 | 3 | 8 | 58 | 1 | |||
18815 | 199909 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1335 Shafter Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 0ft | 6016305.1286 | 2093102.5016 | 37.7281761084423 | -122.385863268846 | (37.7281761084423, -122.385863268846) | 10 | 3 | 8 | 58 | 1 | |||
19003 | 188986 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Maddux Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012667.64033 | 2095215.60548 | 37.7337762895405 | -122.398586505788 | (37.7337762895405, -122.398586505788) | 10 | 3 | 8 | 58 | 1 | |||
19471 | 188996 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1770 La Salle Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014669.28207 | 2096840.44612 | 37.7383490822538 | -122.391779751256 | (37.7383490822538, -122.391779751256) | 10 | 3 | 8 | 58 | 1 | |||
19634 | 53513 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1370 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 11 | Permit Number 12550 | 6015991.6954 | 2093066.1456 | 37.7280589319949 | -122.386944294451 | (37.7280589319949, -122.386944294451) | 10 | 3 | 8 | 58 | 1 | ||
19837 | 200793 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1574 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6015536.4716 | 2095847.5097 | 37.7356707824742 | -122.388712112413 | (37.7356707824742, -122.388712112413) | 10 | 3 | 8 | 58 | 1 | |||
20025 | 200070 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1531 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6015257.2685 | 2093882.9208 | 37.7302609400431 | -122.389540272139 | (37.7302609400431, -122.389540272139) | 10 | 3 | 8 | 58 | 1 | |||
20625 | 188952 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1727 La Salle Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014856.84284 | 2096629.67768 | 37.7377807655571 | -122.391116524617 | (37.7377807655571, -122.391116524617) | 10 | 3 | 8 | 58 | 1 | |||
20911 | 188282 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 11 Rosie Lee Ln | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6018083.14168 | 2094370.92156 | 37.731757175754 | -122.379804637898 | (37.731757175754, -122.379804637898) | 10 | 3 | 8 | 58 | 1 | |||
21349 | 200220 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1151 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014047.4712 | 2090254.411 | 37.7202306272165 | -122.393468896776 | (37.7202306272165, -122.393468896776) | 10 | 3 | 8 | 58 | 1 | |||
22678 | 199908 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1216 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6017309.9205 | 2093127.3901 | 37.7283000004206 | -122.382391361643 | (37.7283000004206, -122.382391361643) | 10 | 3 | 8 | 58 | 1 | |||
22795 | 55186 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 352 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1972 12:00:00 AM | 13 | Permit Number 11096 | 6013396.91313 | 2094278.12637 | 37.7312427671323 | -122.395999500683 | (37.7312427671323, -122.395999500683) | 10 | 3 | 8 | 58 | 1 | ||
23213 | 188987 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 305 Bridgeview Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6012918.63111 | 2094968.59879 | 37.7331120403799 | -122.397701430785 | (37.7331120403799, -122.397701430785) | 10 | 3 | 8 | 58 | 1 | |||
23330 | 188972 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 55 Vesta St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6012266.05718 | 2094101.57422 | 37.7306950098702 | -122.399896704685 | (37.7306950098702, -122.399896704685) | 10 | 3 | 8 | 58 | 1 | |||
23517 | 189018 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1711 La Salle Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6014940.20739 | 2096568.46333 | 37.7376173092958 | -122.390824013816 | (37.7376173092958, -122.390824013816) | 10 | 3 | 8 | 58 | 1 | |||
24630 | 199971 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1255 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6016740.2994 | 2092779.7041 | 37.7273138422776 | -122.384336380249 | (37.7273138422776, -122.384336380249) | 10 | 3 | 8 | 58 | 1 | |||
24664 | 200704 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1466 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6015947.4931 | 2095190.3982 | 37.7338892579459 | -122.387245217903 | (37.7338892579459, -122.387245217903) | 10 | 3 | 8 | 58 | 1 | |||
24776 | 188249 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 950 Key Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6013627.87026 | 2089584.47389 | 37.718367790327 | -122.394872433433 | (37.718367790327, -122.394872433433) | 10 | 3 | 8 | 58 | 1 | |||
24787 | 188993 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 150 Topeka Ave | 3 | : | Tree | Private 2 | 15 | Width 3ft | 6012747.96084 | 2095104.27422 | 37.7334750715082 | -122.398301003391 | (37.7334750715082, -122.398301003391) | 10 | 3 | 8 | 58 | 1 | |||
25457 | 189004 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1743 La Salle Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6014780.96102 | 2096683.31962 | 37.7379238441057 | -122.391382635804 | (37.7379238441057, -122.391382635804) | 10 | 3 | 8 | 58 | 1 | |||
28379 | 188948 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1747 La Salle Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014759.80068 | 2096701.45444 | 37.7379724641572 | -122.391457065516 | (37.7379724641572, -122.391457065516) | 10 | 3 | 8 | 58 | 1 | |||
28525 | 188261 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1339 Hudson Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6017310.47324 | 2095140.94746 | 37.7338288630114 | -122.382529495567 | (37.7338288630114, -122.382529495567) | 10 | 3 | 8 | 58 | 1 | |||
28561 | 188269 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Rosie Lee Ln | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6017903.32503 | 2094505.01761 | 37.7321154566611 | -122.380435623808 | (37.7321154566611, -122.380435623808) | 10 | 3 | 8 | 58 | 1 | |||
28630 | 1883 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 31 Beatrice Ln | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017903.7063488 | 2094083.9229995 | 37.7309592343941 | -122.380405049514 | (37.7309592343941, -122.380405049514) | 10 | 3 | 8 | 58 | 1 | |||
28748 | 188256 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6013789.26124 | 2089763.61893 | 37.7188686596462 | -122.394327104323 | (37.7188686596462, -122.394327104323) | 10 | 3 | 8 | 58 | 1 | ||||
29201 | 199977 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1221 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6016917.6728 | 2092649.1528 | 37.7269651801144 | -122.383714109339 | (37.7269651801144, -122.383714109339) | 10 | 3 | 8 | 58 | 1 | |||
29278 | 188994 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1791 La Salle Ave | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6014563.36259 | 2096847.51308 | 37.7383626062416 | -122.392146465983 | (37.7383626062416, -122.392146465983) | 10 | 3 | 8 | 58 | 1 | |||
30687 | 188268 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 75 Beatrice Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6018091.56 | 2094271.94508 | 37.7314858700568 | -122.379768659608 | (37.7314858700568, -122.379768659608) | 10 | 3 | 8 | 58 | 1 | |||
30996 | 27121 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2335 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2002 12:00:00 AM | 12 | 2x2 | 6013101.69827 | 2096426.31583 | 37.7371248216631 | -122.397170694996 | (37.7371248216631, -122.397170694996) | 10 | 3 | 8 | 58 | 1 | ||
31212 | 108029 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1308 Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6017326.2062 | 2092992.2495 | 37.7279298303143 | -122.382325662572 | (37.7279298303143, -122.382325662572) | 10 | 3 | 8 | 58 | 1 | |||
31416 | 54560 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 55 Maddux Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1972 12:00:00 AM | 10 | Permit Number 10355 | 6012764.33231 | 2095423.50723 | 37.7343525310416 | -122.398266792293 | (37.7343525310416, -122.398266792293) | 10 | 3 | 8 | 58 | 1 | ||
32014 | 199834 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1622 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6014497.2734 | 2092780.1455 | 37.7271907726593 | -122.39209060766 | (37.7271907726593, -122.39209060766) | 10 | 3 | 8 | 58 | 1 | |||
33322 | 99543 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1326 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6016380.5949 | 2093124.5356 | 37.7282407853998 | -122.385603911567 | (37.7282407853998, -122.385603911567) | 10 | 3 | 8 | 58 | 1 | |||
33739 | 200064 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1898 Lane St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6014788.9989 | 2094027.194 | 37.7306311099169 | -122.391169236922 | (37.7306311099169, -122.391169236922) | 10 | 3 | 8 | 58 | 1 | |||
34025 | 27173 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2240 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/1999 12:00:00 AM | 6 | 3X3 | 6012904.02749 | 2096271.59206 | 37.7366889760161 | -122.397843287147 | (37.7366889760161, -122.397843287147) | 10 | 3 | 8 | 58 | 1 | ||
34065 | 199954 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1269 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016683.5619 | 2092823.2211 | 37.7274301939891 | -122.384535553346 | (37.7274301939891, -122.384535553346) | 10 | 3 | 8 | 58 | 1 | |||
34680 | 4896 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Rosie Lee Ln | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/11/1999 12:00:00 AM | 6 | 3X4 | 6018106.77773 | 2094390.54536 | 37.7318123626362 | -122.379724285267 | (37.7318123626362, -122.379724285267) | 10 | 3 | 8 | 58 | 1 | ||
35388 | 188957 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1708 La Salle Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6014940.68574 | 2096639.31184 | 37.7378118713318 | -122.390827309835 | (37.7378118713318, -122.390827309835) | 10 | 3 | 8 | 58 | 1 | |||
35428 | 10789 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1200X Hudson Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x4 | 6017715.9911991 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | 10 | 3 | 8 | 58 | 1 | |||
36390 | 188977 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2000 Thomas Ave | 2 | : | Tree | Private 2 | 12 | Width 3ft | 6012688.07294 | 2095454.36579 | 37.7344330140672 | -122.398532612087 | (37.7344330140672, -122.398532612087) | 10 | 3 | 8 | 58 | 1 | |||
36517 | 188943 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2250 Revere Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6011566.68451 | 2097067.81933 | 37.7388006794984 | -122.402523060487 | (37.7388006794984, -122.402523060487) | 10 | 3 | 8 | 58 | 1 | |||
37008 | 188941 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2250 Revere Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 8ft | 6011606.7054 | 2097039.0351 | 37.738723878306 | -122.402382662836 | (37.738723878306, -122.402382662836) | 10 | 3 | 8 | 58 | 1 | |||
37109 | 188963 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1742 La Salle Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6014798.75794 | 2096747.77521 | 37.7381018136532 | -122.39132560709 | (37.7381018136532, -122.39132560709) | 10 | 3 | 8 | 58 | 1 | |||
37266 | 4898 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Rosie Lee Ln | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017985.0017 | 2094485.55993 | 37.7320665362465 | -122.380151894906 | (37.7320665362465, -122.380151894906) | 10 | 3 | 8 | 58 | 1 | |||
38175 | 56730 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1551 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6015631.7584 | 2095701.097 | 37.7352740434099 | -122.388372450522 | (37.7352740434099, -122.388372450522) | 10 | 3 | 8 | 58 | 1 | ||||
38394 | 202114 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1833 Egbert Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 5ft | 6011999.88588 | 2092811.04962 | 37.7271366533292 | -122.400726278018 | (37.7271366533292, -122.400726278018) | 10 | 3 | 8 | 58 | 1 | |||
38494 | 111261 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 MADDUX AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012644 | 2095211 | 37.7337623267636 | -122.3986679149 | (37.7337623267636, -122.3986679149) | 10 | 3 | 8 | 58 | 1 | ||||
39661 | 103997 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1410X Hawes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6017134.59054 | 2092698.10151 | 37.7271115716676 | -122.38296762653 | (37.7271115716676, -122.38296762653) | 10 | 3 | 8 | 58 | 1 | |||
39679 | 188951 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1735 La Salle Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6014820.98612 | 2096656.00943 | 37.7378510772752 | -122.391242339775 | (37.7378510772752, -122.391242339775) | 10 | 3 | 8 | 58 | 1 | |||
39937 | 10905 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1336 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6017099.8174 | 2095796.95321 | 37.73561848511 | -122.383303451209 | (37.73561848511, -122.383303451209) | 10 | 3 | 8 | 58 | 1 | |||
41031 | 188980 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 77 Robblee Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6012410.68844 | 2095820.65993 | 37.7354233241252 | -122.399517335579 | (37.7354233241252, -122.399517335579) | 10 | 3 | 8 | 58 | 1 | |||
42689 | 188281 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 11 Rosie Lee Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6017931.86479 | 2094462.1595 | 37.7319993514708 | -122.380333977027 | (37.7319993514708, -122.380333977027) | 10 | 3 | 8 | 58 | 1 | |||
42814 | 199837 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1610 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014558.1807 | 2092735.0741 | 37.7270703971337 | -122.391876899677 | (37.7270703971337, -122.391876899677) | 10 | 3 | 8 | 58 | 1 | |||
43028 | 3788 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2 Dukes Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016188.5849089 | 2096210.9026271 | 37.7367047064211 | -122.386482814206 | (37.7367047064211, -122.386482814206) | 10 | 3 | 8 | 58 | 1 | |||
43649 | 53730 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 131 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/1972 12:00:00 AM | 11 | 3x3 | Permit Number 9409 | 6012588.70233 | 2095226.85555 | 37.733802781761 | -122.398860209038 | (37.733802781761, -122.398860209038) | 10 | 3 | 8 | 58 | 1 | |
43867 | 200052 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1447 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6014964.1322 | 2094199.4429 | 37.7311137880856 | -122.390575801186 | (37.7311137880856, -122.390575801186) | 10 | 3 | 8 | 58 | 1 | |||
44455 | 99400 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2201X Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 12 | 3x3 | Permit Number 768917 | 6014717 | 2092863 | 37.7274304716685 | -122.391336797962 | (37.7274304716685, -122.391336797962) | 10 | 3 | 8 | 58 | 1 | |
44911 | 105550 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1200 Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6017193.2263 | 2092868.7457 | 37.7275833669602 | -122.382776791229 | (37.7275833669602, -122.382776791229) | 10 | 3 | 8 | 58 | 1 | |||
45611 | 199968 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400 Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6017172.3791 | 2092782.1982 | 37.7273445726468 | -122.382842840519 | (37.7273445726468, -122.382842840519) | 10 | 3 | 8 | 58 | 1 | |||
45861 | 202030 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1327 Fitzgerald Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 7ft | 6013974.71046 | 2090993.7917 | 37.7222567763217 | -122.393772134473 | (37.7222567763217, -122.393772134473) | 10 | 3 | 8 | 58 | 1 | |||
46297 | 200048 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1590 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6015017.088 | 2094135.7424 | 37.7309418170544 | -122.390388273154 | (37.7309418170544, -122.390388273154) | 10 | 3 | 8 | 58 | 1 | |||
47417 | 188251 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6013763.34518 | 2089782.1261 | 37.7189180360183 | -122.394417981716 | (37.7189180360183, -122.394417981716) | 10 | 3 | 8 | 58 | 1 | ||||
49667 | 53512 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1362 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 11 | Permit Number 12547 | 6016030.8057 | 2093035.8489 | 37.727977908748 | -122.38680697572 | (37.727977908748, -122.38680697572) | 10 | 3 | 8 | 58 | 1 | ||
50381 | 188946 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 398 Quint St | 3 | Front Yard : Yard | Tree | Private 2 | 9 | 6015180.72711 | 2099016.74699 | 37.7443531342865 | -122.390163407814 | (37.7443531342865, -122.390163407814) | 10 | 3 | 8 | 58 | 1 | ||||
52129 | 200713 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1299 Lane St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6015819.5219 | 2095338.0192 | 37.7342875076715 | -122.387697953212 | (37.7342875076715, -122.387697953212) | 10 | 3 | 8 | 58 | 1 | |||
52823 | 188962 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1738 La Salle Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6014828.18654 | 2096725.40837 | 37.7380420321219 | -122.39122229388 | (37.7380420321219, -122.39122229388) | 10 | 3 | 8 | 58 | 1 | |||
52861 | 44282 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1588 Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2001 12:00:00 AM | Permit Number 43704 | 6014189.45600011 | 2095460.4720274 | 37.7345333093335 | -122.393342225003 | (37.7345333093335, -122.393342225003) | 10 | 3 | 8 | 58 | 1 | |||
54030 | 10885 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1270X Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/1997 12:00:00 AM | 6 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | ||
54321 | 199907 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1280 Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016798.1385 | 2093163.3704 | 37.7283705125696 | -122.38416313585 | (37.7283705125696, -122.38416313585) | 10 | 3 | 8 | 58 | 1 | |||
55242 | 188270 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Rosie Lee Ln | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6017725.6269 | 2094584.88968 | 37.7323249627215 | -122.381055522912 | (37.7323249627215, -122.381055522912) | 10 | 3 | 8 | 58 | 1 | |||
56439 | 199830 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1634 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014434.5388 | 2092823.9988 | 37.7273077016708 | -122.392310548197 | (37.7273077016708, -122.392310548197) | 10 | 3 | 8 | 58 | 1 | |||
56699 | 199835 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1618 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6014514.9365 | 2092765.5277 | 37.7271516157866 | -122.392028524189 | (37.7271516157866, -122.392028524189) | 10 | 3 | 8 | 58 | 1 | |||
57231 | 200050 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1590 Shafter Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6014991.2562 | 2094154.9788 | 37.730993203361 | -122.390478922324 | (37.730993203361, -122.390478922324) | 10 | 3 | 8 | 58 | 1 | |||
58006 | 10893 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1270X Hudson Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | |||
58331 | 199920 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1270 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016691.2738 | 2092889.8739 | 37.7276136359457 | -122.384513533626 | (37.7276136359457, -122.384513533626) | 10 | 3 | 8 | 58 | 1 | |||
59405 | 188258 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1339 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017221.78678 | 2095299.66374 | 37.7342597668734 | -122.382847155894 | (37.7342597668734, -122.382847155894) | 10 | 3 | 8 | 58 | 1 | |||
60964 | 10978 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1468X Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016410.2814628 | 2096936.3836856 | 37.7387090009717 | -122.385766856192 | (37.7387090009717, -122.385766856192) | 10 | 3 | 8 | 58 | 1 | |||
61231 | 200761 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1600 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6014709.9165 | 2094018.3408 | 37.7306024118465 | -122.391442020299 | (37.7306024118465, -122.391442020299) | 10 | 3 | 8 | 58 | 1 | |||
61950 | 199932 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1250 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016791.5283 | 2092818.2635 | 37.7274225513541 | -122.384161964499 | (37.7274225513541, -122.384161964499) | 10 | 3 | 8 | 58 | 1 | |||
62000 | 188252 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6013770.43233 | 2089778.01595 | 37.7189071443355 | -122.394393196412 | (37.7189071443355, -122.394393196412) | 10 | 3 | 8 | 58 | 1 | ||||
63918 | 189005 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1746 La Salle Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014786.72658 | 2096751.06079 | 37.7381101674427 | -122.391367435462 | (37.7381101674427, -122.391367435462) | 10 | 3 | 8 | 58 | 1 | |||
65153 | 54559 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 51 Maddux Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1972 12:00:00 AM | 10 | Permit Number 10354 | 6012768.0788 | 2095448.27942 | 37.7344207590186 | -122.398255576836 | (37.7344207590186, -122.398255576836) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );